PC Review


Reply
Thread Tools Rate Thread

How to access a downloaded file before VBA ends

 
 
JExec
Guest
Posts: n/a
 
      3rd Nov 2006
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 With Quote
 
 
 
 
=?Utf-8?B?VG9tIE9naWx2eQ==?=
Guest
Posts: n/a
 
      3rd Nov 2006
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 With Quote
 
JExec
Guest
Posts: n/a
 
      6th Nov 2006
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 With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
access 99% finished downloaded file from TIF folder liu Windows XP General 1 1st May 2008 02:29 PM
How do I give others access to a file downloaded onto FileCrunch? Margaret Cadigan Microsoft Word Document Management 2 13th Jan 2008 02:06 AM
Access 2003 just ends Wayne Veale Microsoft Access 15 22nd Nov 2006 09:09 PM
Email from Access - TO ends up in BCC SAC Microsoft Access 5 30th Nov 2003 07:54 PM
Compacting front ends and back ends Deb Struble Microsoft Access Database Table Design 2 15th Sep 2003 06:05 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:57 PM.