Waiting for Refresh to done

I need help with VBScript.
Using active X script of SQL 2000 DTS package, I am trying to open an
Excel workbook, refresh data, save workbook and close the workbook.

I have code to do all that, but I have problem with timing issue
between Refresh command and save workbook command. I don't have enough
time between refresh and save commands.
I am doing this to several workbooks that I can't set fix time. I need
to find a way to parse until refresh is done and go on to next step.

Is there a command to do this?

Thanks for any help you can give...

gimme_this_gimme_that
Mon Jan 29 16:23:46 CST 2007

To refresh after 15 seconds ... put this in your header.

<META HTTP-EQUIV="REFRESH" CONTENT="15;URL=HomePageTwo.html">
</HEAD>

Ayush
Mon Jan 29 16:32:49 CST 2007

Replied to [jwl770@yahoo.com]s message :
> I need help with VBScript.
> Using active X script of SQL 2000 DTS package, I am trying to open an
> Excel workbook, refresh data, save workbook and close the workbook.
>
> I have code to do all that, but I have problem with timing issue
> between Refresh command and save workbook command. I don't have enough
> time between refresh and save commands.
> I am doing this to several workbooks that I can't set fix time. I need
> to find a way to parse until refresh is done and go on to next step.
>
> Is there a command to do this?
>
> Thanks for any help you can give...
>

WScript.Sleep milliseconds

--
â?? Ayush
-------------
Search - www.Google.com | Wikipedia - http://en.wikipedia.org
Snip your long urls - http://snipurl.com/
-------------

jwl770
Tue Jan 30 07:31:20 CST 2007

I don't know how long each refresh will take, so I can't use fixed
time.
I need a way to know whether refresh is done or not.



On Jan 29, 1:53 pm, "jwl...@yahoo.com" <jwl...@yahoo.com> wrote:
> I need help with VBScript.
> Using active X script of SQL 2000 DTS package, I am trying to open an
> Excel workbook, refresh data, save workbook and close the workbook.
>
> I have code to do all that, but I have problem with timing issue
> between Refresh command and save workbook command. I don't have enough
> time between refresh and save commands.
> I am doing this to several workbooks that I can't set fix time. I need
> to find a way to parse until refresh is done and go on to next step.
>
> Is there a command to do this?
>
> Thanks for any help you can give...

TDM
Tue Jan 30 09:41:36 CST 2007


<jwl770@yahoo.com> wrote in message
news:1170096835.342518.76230@p10g2000cwp.googlegroups.com...
>I need help with VBScript.
> Using active X script of SQL 2000 DTS package, I am trying to open an
> Excel workbook, refresh data, save workbook and close the workbook.
>
> I have code to do all that, but I have problem with timing issue
> between Refresh command and save workbook command. I don't have enough
> time between refresh and save commands.
> I am doing this to several workbooks that I can't set fix time. I need
> to find a way to parse until refresh is done and go on to next step.
>
> Is there a command to do this?
>
> Thanks for any help you can give...
>

There is a Refreshing property, and a few examples in the VBA
help. Have you tried using that ?

TDM