L
LV System
I have a client with 2 computers. One works, the other got problems.
Both systems have: Windows XP Pro, Office XP Pro, custom macros
The bad system behaves as follows:
Double click an excel worksheet, Excel runs but it opens no file, it is
grey.
Custom macro when run will cause Word to display a message that
"Wating for Excell to Accept DDE command" and then nothin happans.
(Function of macro: it is written in VBasic, is inported using Word's
macro/visual basic editor function. Macro supposed to open a worksheet in
Excel,
pull info from it and put it into the Word document.
This macro works on the "good" machine A-OK)
I tried followings:
delete the XLS association via explorer/folder options and then
let windows re-create it when it asks for what program to use to open the
doubleclicked worksheet. This did not help.
I compared registry entries of the 2 machine in the are of
..xls
file association
DDE (relating to Word and Excel)
I found them to be the same, unless I missed something. (Registry is HUGE,
99.9 Megabytes)
Did a "repair" of the Office installation. It stopped with error. Looking up
the error number
on Microsoft site I followed the fix to install Mdac. After this the
"repair" worked OK.
But problem remained!!!!!
I decided to delete the macros in Word, delete the custom toolbar also and
re-create it from scratch. When Word was started again the "old toolbar"
came back!
I deleted the "normal.dot" that belonged to the user and let Word make-anew.
Recreated the macro and toolbar. Now I could delete the toolbar without it
coming back.
Obviously the original "normal.dot" was corrupt.
Is there a "normal.dot" type of file that Excel uses?
I can't quite tell if problem is Explorer, Excel or registry.
Are there specific reg entries I should be looking for?
Both systems have: Windows XP Pro, Office XP Pro, custom macros
The bad system behaves as follows:
Double click an excel worksheet, Excel runs but it opens no file, it is
grey.
Custom macro when run will cause Word to display a message that
"Wating for Excell to Accept DDE command" and then nothin happans.
(Function of macro: it is written in VBasic, is inported using Word's
macro/visual basic editor function. Macro supposed to open a worksheet in
Excel,
pull info from it and put it into the Word document.
This macro works on the "good" machine A-OK)
I tried followings:
delete the XLS association via explorer/folder options and then
let windows re-create it when it asks for what program to use to open the
doubleclicked worksheet. This did not help.
I compared registry entries of the 2 machine in the are of
..xls
file association
DDE (relating to Word and Excel)
I found them to be the same, unless I missed something. (Registry is HUGE,
99.9 Megabytes)
Did a "repair" of the Office installation. It stopped with error. Looking up
the error number
on Microsoft site I followed the fix to install Mdac. After this the
"repair" worked OK.
But problem remained!!!!!
I decided to delete the macros in Word, delete the custom toolbar also and
re-create it from scratch. When Word was started again the "old toolbar"
came back!
I deleted the "normal.dot" that belonged to the user and let Word make-anew.
Recreated the macro and toolbar. Now I could delete the toolbar without it
coming back.
Obviously the original "normal.dot" was corrupt.
Is there a "normal.dot" type of file that Excel uses?
I can't quite tell if problem is Explorer, Excel or registry.
Are there specific reg entries I should be looking for?