View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.setup
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default cannot open Excel file from Explorer

Are you using xl2007?

If you are...

You are suffering from a common problem that lots of people have complained
about. The workbook is open, just not visible.

One way to see it is to click on the Office button and start to open another
workbook, but then just dismiss the dialog. You may see your workbook open
after this. (Ctrl-O, then escape may work???)

Currently, there isn't a fix--just workarounds.

Supicek wrote:

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


--

Dave Peterson