automatically open excell documents according to schedule

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I'm looking for some advice on how to make Excell launch and then open up
spreadsheets in a read only format for viewing by my users. I have 2
seperate spreadsheets that I would like to open up individually at one minute
intervals from each other and then close after one minute so that the other
spreadsheet can open and display it's information. Think of it as a changing
status board on job output for employees. Are there any programs out there I
can use? I've looked at using EZ-Scheduler and AutoIT to accomplish this but
I thought I would also make a post here to see if anyone had any ideas as to
an easy way to accomplish this.

Thanks!
 
Justin -

Could you put both sheets into one workbook? It seems to me you could open the
workbook by putting the file into the xlstart folder, and put a shortcut to Excel in
the startup folder of the windows start menu. In the workbook you'd have some simple
code. In the ThisWorkbook code module:

Sub Workbook_Open()
OnTime Now + TimeValue("00:01:00"), "SwitchSheets"
End Sub

In a regular code module:

Sub SwitchSheets()
If ActiveSheet.Name = "Sheet1" then
Worksheets("Sheet2").Activate
else
Worksheets("Sheet1").Activate
End If
OnTime Now + TimeValue("00:01:00"), "SwitchSheets"
End Sub

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Back
Top