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?
|