Vba upload file to server

Here is what I have done so far:. The message boxes at the bottom of the script do output the server's headers and response blank HTML page. I feel that there is something that I am not setting in the headers to make the server happy note: trying commenting out Content-Type.

Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. Ask Question. Asked 9 years, 7 months ago. Active 5 years ago. Viewed 35k times. EDIT -- Aug. MsgBox WinHttpReq. Community Bot 1 1 1 silver badge. What kind of files: text or binary? Would you be able to send the files one by one? Or is that not an option?

I checked out the link and it looks like you had a problem with submitting the form that Eggcel helped you with. I had this problem earlier but overcame it I just need to figure out how to upload a file to the webpage. If the webpage is a webform If it's FTP, or some javascript upload, then you're past me.

Oh, I see the confusion. It's the same dialog that appears when you want to open or save a document, for example, on your computer. Clicking "Open" uploads the file, and the webpage refreshes with a thumbnail of the image that I uploaded. The refresh part is not a problem, I just need to figure out how to interact with the filedialog.

If you can type in the file name or copy paste into the webpage form, then you can avoid the IE dialogue altogether and use VBA to "paste" the file name into the form. Alternatively, in your code above, you could try:. Hey Aaron, I really appreciate your help on this. I tried your solution and it didn't do anything no action in IE , and also didn't error in VB 6. I tried a variant that also didn't work:.

Did you have a look at this thread. The op was trying to do something very similar to you. If you follow the links that I posted in that thread you will find that it is intentionally difficult to do what you are attempting as a security precaution. The op was able to find a workaround, but I don't know how much that will help you or not.

It is pretty in depth and detailed. To be honest, without sitting and studying what he did for a time, I would not be able to direct any assistance. Ah, thanks for the insight Eggcel. It does make sense that it should be difficult. You must log in or register to reply here. Similar threads.

Replies 0 Views Sep 5, mehidy Vj Jul 30, Excel Questions. Replies 1 Views Replies 2 Views Sep 22, Mackeral. ClaireLou Sep 22, Excel Questions.

Sep 22, johnnyL. Question Check for file needed that will be in 1 of 2 locations. Replies 16 Views Aug 8, johnnyL. Understanding data is crucial, and the easiest place to start is with Microsoft Excel. Forum statistics Threads 1,, Messages 5,, Members , Latest member sannel We've detected that you are using an adblocker. We have a great community of people providing Excel help here, but the hosting costs are enormous.