Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to access a downloaded file before VBA ends
How are you downloading the file. What commands are you using?
-- Regards, Tom Ogilvy "JExec" wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to access a downloaded file before VBA ends
Thanks Tom for replying. I'm simulating web browsing and using sendkey
{ENTER} to do the actual "open" command on the file download prompt. Tom Ogilvy wrote: How are you downloading the file. What commands are you using? -- Regards, Tom Ogilvy "JExec" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can i open an e mail with attached file that ends with xls | New Users to Excel | |||
open downloaded .csv file | Excel Discussion (Misc queries) | |||
How do I access trial version files after grace period ends? | Charts and Charting in Excel | |||
Excel file downloaded and lost HELP!!!!!!!!!!!! | Excel Discussion (Misc queries) | |||
How to remove commas from a downloaded .dat file? | Excel Worksheet Functions |