![]() ![]() Loop Until IE.ReadyState = READYSTATE_COMPLETE Set IE = CreateObject("InternetExplorer.Application") SWR_url = "" & SWR_start_date & "¶meter_2=" & SWR_end_date ' note: user must be logged into intranet before executing this VBA ' set reference to Microsoft Internet Controls This surely is a common question, but I've spent hours searching the Forum and can't find any real answers to this. to automatically save the file and then continue the VBA? Is there some way for the VBA to search for all open windows, and continually look for a window to appear with the title = "File Download", and then somehow hit the save button and then do the same with the "Save As" dialog box window. ![]() What of course I want VBA to do next is to automatically save the file with the desired name and path which is known within the VBA. When I manually hit the SAVE button, this then brings up another typical dialog box titled "SAVE AS", with a scrollable list of files and the SAVE or CANCEL button. The title of the window is "File Download", with the question, "Do you want to open or save this file?", with 3 buttons, HOW CAN VBA automatically wait for this window to finally appear, and then process it as desired by saving the file with my chosen filename? and EVENTUALLY (30-90 seconds later) a "File Download" Windows dialog box appears. My Excel VBA successfully opens Internet Explorer and requests an intranet file download.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |