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

[March]

Hello All,

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

Please give me suggestion.

Thanks,


March

 

[JLGWhiz]

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.

 

[March]

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