Excel worksheet will not open

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

TaurArian [MS-MVP]

There are specific Newsgroups for Excel

OE client For Excel:-
news://msnews.microsoft.com/microsoft.public.excel
news://msnews.microsoft.com/microsoft.public.excel.misc
news://msnews.microsoft.com/microsoft.public.excel.newusers
news://msnews.microsoft.com/microsoft.public.excel.setup
news://msnews.microsoft.com/microsoft.public.excel.programming
news://msnews.microsoft.com/microsoft.public.excel.worksheet.functions

For Web -
http://www.microsoft.com/office/community/en-us/FlyoutOverview.mspx#2


--

===========================
TaurArian [MS-MVP] 2005-2006
===========================
http://www.dts-l.org/goodpost.htm
"Need more help? http://support.microsoft.com/?scid=ph;en-us;6527
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top