View Single Post
  #2   Report Post  
Bernie Deitrick
 
Posts: n/a
Default

Gee,

You could move that file to another folder, and then use the workbook open event of another workbook
to schedule a macro that will open your workbook that needs to wait. For example, if your workbook
is named "Needs Delay.xls", and is in the folder C:\Excel, put this into the codemodule of the
ThiswWorkbook object of a file that is in your start-up folder:

Private Sub Workbook_Open()
Application.OnTime Now() + TimeValue("00:00:15"), "OpenItLater"
End Sub

And put this into a regular codemodule in that same book:

Sub OpenItLater()
Workbooks.Open "C:\Excel\Needs Delay.xls"
End Sub

Then the file "C:\Excel\Needs Delay.xls" will be opened 15 seconds after the other file is opened.

HTH,
Bernie
MS Excel MVP


"Gee" wrote in message ...
Hi all,

I have an excel spreadsheet that starts up from the start-up folder. The
problem is that it starts up before another program does that imports DDE
data into the spreadsheet. This would then cause the spreadsheet to hang. Is
it possible to place a delay statement in the start-up line that would delay
the excel spreadsheet for 5 or 10 seconds.

Thanks for the help.