How to open multi-workbooks w/ Window Scheduled Task?

  • Thread starter Thread starter March
  • Start date Start date
M

March

Hello All,

I wouls like to know how to open multi-workbooks w/ Window Scheduled Task.

Please give me suggestion.

Thanks,


March
 
If I was doing it, I would write a macro to open the multiple workbooks, then
use the scheduled tasks facility to run that macro.
 
I have done that way, however, I cannot get my workbook updated with all
values link from another source, not excel.

Then I have to setup to workbooks run on the scheduled task.

I need to know how to write vba to open the workbook in the same excel
object, if once is already opened on the sceen.


March
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Scheduled task method of opening Excel questions. 1
Reference a workbook level named variable. 8
Schedule downloads 1
Schedule downloads 1
Update Links, Scheduled Tasks and UDFs 2
Schedule downloads in VBA 5
Task Scheduler or VBA to simple copy periodically folders contents toexternal drive 1
Routine does not run when workbook is opened 1

Back
Top