Re: Upload file without user interaction - VBA

The OP does not seem confused to me - requirements seem clear that the only
available method is using an HTTP form and the POST method. The question is
then how to automate this process.

Never tried this, but one possibility might be to automate IE to upload the
files. The on sticking point may be that for obvious reasons the "file"
input element does not allow setting the value (path) through script: not
sure if this extends to automation from outside of IE.

Tim


"Joel" <Joel@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:71D8F145-2EF0-40A0-82F7-58B3B374F8F3@xxxxxxxxxxxxxxxx
I'm not an expert on this, but I think you arre a little confused in what
you
are asking for. I think you need to transfer a file, not send the text
data
line by line. You probably need to use FTP, not HTTP.

FTP is File Transfer Protocol. HTTP is Hyper-Text Transfer Protocol. HTTP
sends the text character inside a file and displays the text to a screen.
FTP just send the files between two computers but doesn't display the
text.

Your posting first says I want to upload files which is FTP.

"google.com@xxxxxxxxx" wrote:

Hi !

I would like to upload files to a Webserver, but the problem is that
the server only accepts uploads via FORM. The form looks like this:

<form action="upload.asp?
action=upload&type=product&item=pic1&element=&id=3170&w=1000&h=1000&maxw=200&maxh=5000"
method="post" name="upload" enctype="multipart/form-data">
<input type="hidden" name="type" value="product">
<input type="hidden" name="item" value="pic1">
<input type="hidden" name="element" value="">
<input type="hidden" name="id" value="3170">
<input type="hidden" name="w" value="1000">
<input type="hidden" name="h" value="1000">
<input type="file" name="picture" size="28">
<input type="submit" value=" upload "">
</form>

So my question is, how do I create a sub in vba/excel, which looks
like this:

public sub UploadFile( FileToUpload as string)

The sub should read the file FileToUpload, and post it on the
webserver using the form.

Any help appreciated, because I have to upload 1000+ files 8-()


/hco




.

Relevant Pages

  • Re: http uploading
    ... It's not unusual for ftp password to be different. ... | It seems that the password that you use to upload through http is the FPSE ... |> My problem with http has only appeared now i have crossed over to Vista. ...
    (microsoft.public.publisher.webdesign)
  • Re: Problem with FTP
    ... Both protocols will upload your site files, but http uses FP extensions on ... the server (means your server host had to install them), whereas ftp is the ...
    (microsoft.public.publisher.webdesign)
  • Re: Word = Web
    ... you may use standard methods of FTP ... or HTTP to upload FP files. ... Here are some beginner links. ...
    (microsoft.public.word.docmanagement)
  • Re: HTTP speed much lower than FTP speed for same file
    ... When doing FTP with HTTP, the HTTP encapsulates a special form of ... "read-only/download-only" FTP inside the HTTP packet. ... able to download and not upload. ... ASP based upload but the scripting for it is very extensive. ...
    (microsoft.public.win2000.networking)
  • Re: Publisher and 1&1
    ... In other words, clean up the folder. ... change the FTP proxy settings to allow ... To use Publisher read the following ... this is your root directory and where you upload your Publisher ...
    (microsoft.public.publisher.webdesign)