View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.setup
Supicek Supicek is offline
external usenet poster
 
Posts: 3
Default cannot open Excel file from Explorer

Hi,

at startup location I have one xls file which creates additinal menu option
and then hide itself. Recently I have created a welcome splash screen which
appears at thisworkobook.open event

***********
Private Sub Workbook_Open()

Application.Wait (Now + TimeValue("0:00:10"))
myWorkbookName = ThisWorkbook.Name
Windows(myWorkbookName).Visible = False
frmLogo.Show

Call CreateMenuOraculum

End Sub
************


everything works fine apart of opening an excel file from Windows
explorer/Total commander by double click. If Excel is already running then
the clicked files are correctly opened, however if Excel is not running then
the file is not opened.

When I couble click the excel file - the Excel is launched, the file at
startup location is opened (menu is created and the splash screen appeares)
however the clicked file is not opened. I have to click the file again after
Excel is launched.

Any idea how to correct it?

--
Supicek