
08-17-2009
|
|
|
|
Re: Word Docs Don't Exhibit In Vista Explorer Preview Pane
I came across this thread when trying to nut out an Excel issue on
Vista. It turns out that there are a number of interesting nasties
associated with certain file types when using the new Vista Preview Pane
(in Windows Explorer), not seen in XP or even in Vista when the Preview
Pane is not displayed.
My Excel spreadsheets are actually mini applications with embedded VBA.
When I click once on the application/XLS (yes, they started life as an
XLS), Excel.EXE gets called to generate the preview. If you
double-click, the app opens normally and executes, until you save/exit
(big red X).
At this time the underlying Windows Explorer window is locked with a
"ping" sound on every click attempt. The only way to exit is
Alt-Ctrl-Del and use Task Manager to kill the explorer window.
When you next enter the Excel, it also dies again, but this time resets
the spreadsheet, so the third use it is clean...so long as you don't use
the Preview Pane.
As workarounds:
- Turn off Preview Pane (Organize, Layout, Preview Pane)
- Don't click once before opening the file/app which generates the
preview, just double click with another file selected
- Open Excel as an application, and use the Recent Documents list
- Double click from an email attachment or the desktop (these both work
as there is no preview pane option)
I guess there are two other points:
- Rename the XLS to XLSM - as curiously there is no application linked
to XLSM as a preview generator
- Somehow, we need to find out whether there is a code limitation which
causes this to happen. I have tried trivial macros and cannot recreate
the problem, but any XLS "application" dies in the same way, virtually
every time.
Oh, the final option would be for MS to write a fix for this.
I've written this in the interests of it being probably related to the
previous (old) thread, as I can't see that the issue has been addressed
since then.
CT
--
CTVF
|