View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
March March is offline
external usenet poster
 
Posts: 34
Default How to open multi-workbooks w/ Window Scheduled Task?

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


"JLGWhiz" wrote:

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" wrote:

Hello All,

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

Please give me suggestion.

Thanks,


March