Application AutoRun or AutoStart

[pbellc]

I don't know if Visual Basic can actually do this or not, but it can't hurt to ask. I need a file to automatically open every evening at a specific time. The file is an Excel file and it will reside on a Unix box. Any suggestions would be fantastic, be they VB or anything else.

Thanks.

 

[AndyWatt]

If you periodically examine the system time using the Timer event of a timer:

Sub Timer1_Timer()
Dim objXlApp as Excel.Application

If Format(Now,"HH:mm&quot = "18:00" then
' Do Stuff
Set objXlApp = New Excel.Application
With objXlApp
.Visible = True
.WindowState = xlMinimized
.Workbooks.Open <Spreadsheet filename goes here>
End With
End If
End Sub

&quot;Logic is invincible because in order to combat logic it is necessary to use logic.&quot; -- Pierre Boutroux

 

[pbellc]

THanks, AndyWatt. I'm glad to know that this is possible. My next question is (and this may sound a little basic) is: Where do I put that code? If I want this to open Excel, I can't write it in VB in Excel. So where else can I put it? THanks.

 

[AndyWatt]

I'm guessing that you are writing a VB application to manipulate this Excel spreadsheet.

I'd suggest that the best place for the code is in the Timer event of a Timer control dropped onto a Form.

Regards,

Andy


&quot;Logic is invincible because in order to combat logic it is necessary to use logic.&quot; -- Pierre Boutroux