Open file at certain times of day...,

  • Thread starter Thread starter Jay Gustafson
  • Start date Start date
J

Jay Gustafson

Hello,

Is it possible to do this by using a macro or coding?

1.) Every hour between 8 am & 6 pm. Excel opens up a file at a specific location.
2.) Once the file is open it copies all the values on the sheet, pastes those values to a new workbook.
3.) Then closes out the origional file it had opened?

There's slighly more information to my question, but unless this can be done there's no sense in getting into more specifics.

I have high doubts this is even possible, but I've been suprised at what Excel can do so far, so I figured I'd give it a shot.

Thanks,
Jay Gustafson
 
Hi Jay
possible BUT Excel has to run the whole time. This would use the OnTime
method (see: http://www.cpearson.com/excel/ontime.htm). But you may
consider using a stand alone program for this (a scheduling program on
the OS level) which opens an Excel file. In this Excel file you could
use the Workbook_open event for your coding
 
Back
Top