View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JExec JExec is offline
external usenet poster
 
Posts: 2
Default How to access a downloaded file before VBA ends

I'm having problems accessing a file that was downloaded via VB. The
file does not appear until all code is executed. I need to copy and
paste data from the downloaded file to an existing file. I tried using
wait and sleep but nothing works. It seems the only thing that will
work is to simulate hitting the reset button, wait a few seconds for
the file to load, and then run the rest of the code. I need to be able
to do this so that an end user won't be able to know whats going on (ie
the visual basic window should never be visible). Any ideas??


Thanks in advance!

Josh