Excel 2007 Update External Data in time Without Openning

[Salut39]

Hi Everyone,

I have spreadsheet link via Ms Query to external database.
I can update reports manually or on openning by "Refresh All" but users need it first thing and some not have the link to database.
My Question: Is it possible to update data without openning a file at say midnight.
My VBA skills go as far as coping code to a module so if someone has a solution please send the the whole code please.

Thanks
Yuri

 

[SkipVought]

hi,

Do you mean, is it possible to connect to the other workbook without actually connecting to the other workbook?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[Salut39]

No, I have connection to data via ms query I have a report which I refresh every day. I want to refresh this connection at midnight without openning actual spreadsheet so it's refreshed with a new date by the morning.

 

[SkipVought]

If your workbook that has the querytable 1) is not open or 2) does not refresh the external workbook at whatever time you require, then the required data will not be there.

You need to 1) have the workbook open and 2) have an Application.OnTime executed and waiting, that will run the refresh at the proper time.

Check out the Application.OnTime Method.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[Salut39]

Thanks I'll check it out.