View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Neil Law Neil Law is offline
external usenet poster
 
Posts: 2
Default 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.