View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
JP[_4_] JP[_4_] is offline
external usenet poster
 
Posts: 897
Default Excel doesn't open up when double-clicking the file in Explorer

It's probably because Excel is running (I assume VBA) in the
background.

Try adding a DoEvents Function call to your code, to give control back
to the OS temporarily.

--JP

On Oct 2, 3:30*pm, Ming wrote:
When double-clicking an excel file in Window Explorer, Excel normally opens
up the file automatically. This is working fine on my PC usually. However, if
I have an Excel process running in background (generating reports in silent
mode), double-clicking the file doesn't work. Sometimes (very rare) it comes
up, but mostly you see nothing.

If I open up Excel application first, then use its menu to open the file,
then there is no problem.

I found similar complains on the Internet, but most of them happen under
"normal" conditions. On my machine, it works fine under "normal" conditions.

Any idea?