chrisexcel
Programmer
Hi All,
I am using Excel VBA to access the Internet. I have no problem opening an IE page and going to the appropriate pages as needed. The problem is that I need to upload a file to this particular website. After the code executes the click of the "Browse" button the Upload Dialog Box appears.
I have tried SendKeys thereafter in placing the file and its path in the textbox and tabbing to the open button. However this does not work. I get the message "Microsoft Office Excel is waiting for another application to complete OLE action." and the code stalls.
Does anyone have a work around that or can give a VBA code example. Ironically I am able to use SendKeys to the download dialog box but obviously the two are different. Please help!
Chris
I am using Excel VBA to access the Internet. I have no problem opening an IE page and going to the appropriate pages as needed. The problem is that I need to upload a file to this particular website. After the code executes the click of the "Browse" button the Upload Dialog Box appears.
I have tried SendKeys thereafter in placing the file and its path in the textbox and tabbing to the open button. However this does not work. I get the message "Microsoft Office Excel is waiting for another application to complete OLE action." and the code stalls.
Does anyone have a work around that or can give a VBA code example. Ironically I am able to use SendKeys to the download dialog box but obviously the two are different. Please help!
Chris
