How to download into Excel from web?
I've written VBA code that will invoke a URL to open a page and then invoke
another to download an excel file.
The problem I'm running into is I seem to get the download complete before
the file is into excel which is causing other problems.
The security window does come up to ask if I want to open or save the file.
I can't figure out how to disable this but I think that, even if I do, it
will not help.
Any suggestions or pointers would be appreciated.
|