I've created a macro that will open Internet Explorer (setting IE as an object), wait for a web page to load and then press a button on that page to download a file. The problem that I am running into is that when the button for file download is pressed a diologue box pops up asking what I would like to to with the file (i.e. open, save, cancel, etc). Given that this is a .csv file (MS Excel), I am unable to "uncheck" the box that would prevent this diologue box from poping up.
The real problem occurs when IE takes a while to load the dialogue box causing my macro to go screwy . I need a way to tell the macro to keep waiting until the diologue box appears before continuing. Either that or find a way to get rid of the diologue box all together.
I know this is probably more confusing than helpful but I'm at a loss as to how else to explain the situation. Any help at all would be appreciated.
The real problem occurs when IE takes a while to load the dialogue box causing my macro to go screwy . I need a way to tell the macro to keep waiting until the diologue box appears before continuing. Either that or find a way to get rid of the diologue box all together.
I know this is probably more confusing than helpful but I'm at a loss as to how else to explain the situation. Any help at all would be appreciated.