C
Crombinator
For the record the machine is running WindowsXP, and Office 2003 with
all recent updates from Windows/Office Update. There have been no
'weird' tweaks applied to the machine, and it is a straight install
with the 'Full Install' option in Office.
What is happening is that when I double-click on an Excel file Excel
opens without the 'hidden' worksheet loaded so I have none of my
macros.
The fix that worked for a bit seemed to be to copy/paste all of my
macros out of that document into a text file, wipe out the hidden
file, create a new one, and then re-compile the macros.
My problem is this has recently stopped working, and even a complete
reinstall of Office has not resolved the issue. Has anyone run into
this, and what fixes did you try?
For the time being my only work-around is to always have Excel open.
The funny thing is I have never had this issue at home with the exact
same setup installed. It only happens on my work machine.
On further research the issue could be some odd profile issue. I am
going to wager something to do with Netware since this does not happen
at home. The installed shortcut for Excel opens it properly, and
obviously points Excel to the XLSTART folder.
Double-clicking on a file does not access the XLSTART folder at all no
matter where I save it (profile data, Office11 folder, All Users
profile, etc).
The other weird thing is that the 'Recent Files' list is different
depending on whether or not I double-click on a file to open Excel, or
I open Excel from it's Start Menu shortcut (or from a manually created
shortcut).
Finally, just to add this to the error message on Google search I get
the error: 'Personal macro workbook in the startup folder must stay
open for recording' whenever I try to record a new macro to the
Personal Workbook in Excel when I open it by double-clicking on an
Excel file.
So far my steps have been:
1) Delete PERSONAL.XLS from all locations
2) Re-register Excel using the Excel /unregserver and then /regserver
from Start | Run...
3) Re-create the macros, and re-compile the worksheet
4) Copy that version of PERSONAL.XLS in all profiles on the computer
along with in Program Files/Office/Office11/XLSTART
5) Delete the entry for XLS in the folder options, and create a new
one
6) Completely nuke Office from the machine, and reinstall
7) Completely nuke Windows XP, and reinstall everything from scratch
Any thoughts?
all recent updates from Windows/Office Update. There have been no
'weird' tweaks applied to the machine, and it is a straight install
with the 'Full Install' option in Office.
What is happening is that when I double-click on an Excel file Excel
opens without the 'hidden' worksheet loaded so I have none of my
macros.
The fix that worked for a bit seemed to be to copy/paste all of my
macros out of that document into a text file, wipe out the hidden
file, create a new one, and then re-compile the macros.
My problem is this has recently stopped working, and even a complete
reinstall of Office has not resolved the issue. Has anyone run into
this, and what fixes did you try?
For the time being my only work-around is to always have Excel open.
The funny thing is I have never had this issue at home with the exact
same setup installed. It only happens on my work machine.
On further research the issue could be some odd profile issue. I am
going to wager something to do with Netware since this does not happen
at home. The installed shortcut for Excel opens it properly, and
obviously points Excel to the XLSTART folder.
Double-clicking on a file does not access the XLSTART folder at all no
matter where I save it (profile data, Office11 folder, All Users
profile, etc).
The other weird thing is that the 'Recent Files' list is different
depending on whether or not I double-click on a file to open Excel, or
I open Excel from it's Start Menu shortcut (or from a manually created
shortcut).
Finally, just to add this to the error message on Google search I get
the error: 'Personal macro workbook in the startup folder must stay
open for recording' whenever I try to record a new macro to the
Personal Workbook in Excel when I open it by double-clicking on an
Excel file.
So far my steps have been:
1) Delete PERSONAL.XLS from all locations
2) Re-register Excel using the Excel /unregserver and then /regserver
from Start | Run...
3) Re-create the macros, and re-compile the worksheet
4) Copy that version of PERSONAL.XLS in all profiles on the computer
along with in Program Files/Office/Office11/XLSTART
5) Delete the entry for XLS in the folder options, and create a new
one
6) Completely nuke Office from the machine, and reinstall
7) Completely nuke Windows XP, and reinstall everything from scratch
Any thoughts?