Macros in Personal.xls Not Accessible

  • Thread starter k.vanderstarren
  • Start date
K

k.vanderstarren

Hi There,

I'm using Office XP and I'm having a problem with the macros
registered in my personal.xls file. When I launch Excel manually, the
macros are accessible and function correctly. The macros do no work
however when Excel is launched by a specific third-party program that
I have. I have tried a bunch of things to get the macros working but
I'm stumped. If anyone can offer any suggestions, it would be greatly
appreciated. I've tried the following so far:

1. Deleting the personal.xls file and recreating it through Excel.
Excel created the file in "C:\Documents and Settings\[USER_NAME]
\Application Data\Microsoft\Excel\XLSTART" rather than "C:\Program
Files\Microsoft Office\Office10\XLStart". I found this a little odd.

2. Copying the personal.xls created in the "Documents and Settings"
folder (see 1) into the XLStart folder in the "Program Files" folder.

2. A repair of Office

3. A reinstall of Office


Thanks!
Kris
 
C

Chip Pearson

You didn't need to repair and/or reinstall Office. When Excel is started via
Automation, it doesn't load the startup files. This is to minimize the
startup time for Excel. If you need your personal.xls file open, you'll have
to do it yourself or get the automation code to do it.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)
 
D

Dave Peterson

Excel won't load other workbooks/addins when you start excel this way.

Maybe you can change your other program to open your personal.xls workbook,
too????

Hi There,

I'm using Office XP and I'm having a problem with the macros
registered in my personal.xls file. When I launch Excel manually, the
macros are accessible and function correctly. The macros do no work
however when Excel is launched by a specific third-party program that
I have. I have tried a bunch of things to get the macros working but
I'm stumped. If anyone can offer any suggestions, it would be greatly
appreciated. I've tried the following so far:

1. Deleting the personal.xls file and recreating it through Excel.
Excel created the file in "C:\Documents and Settings\[USER_NAME]
\Application Data\Microsoft\Excel\XLSTART" rather than "C:\Program
Files\Microsoft Office\Office10\XLStart". I found this a little odd.

2. Copying the personal.xls created in the "Documents and Settings"
folder (see 1) into the XLStart folder in the "Program Files" folder.

2. A repair of Office

3. A reinstall of Office

Thanks!
Kris
 
K

k.vanderstarren

Thank you for the responses Dave and Chip. I'm a little confused now
because this is working on anther computer that is running Excel 2003.
There are macros in the personal.xls file and they are loaded each
time Excel is launched by the third-party application. On the computer
that works, once Excel is launched by the third-party application, I
can go to Window-->Unhide and unhide the personal.xls file. On the
computer that doesn't work, this option is grayed out. Do either of
you have any thoughts on what might be going on?

Thanks,
Kris
 
D

Dave Peterson

Are you sure how the other program starts excel?

Are you sure that if there's an instance of excel running, that it just doesn't
use that instance?
 
K

k.vanderstarren

Hi Dave. I'm pretty sure the program starts Excel. It is a custom
application developed by a third-party vendor. The GUI for the program
has a button you click to open a copy of a specific Excel template
(xlt file). The xlt files are accessible in a directory on the
computer so they can be modified if necessary. When I open those
templates manually, all of my macros work but when the program opens
them, the macros do not work.

Thanks again for your help,
Kris
 
D

Dave Peterson

It sounds like the program is starting excel, then loading the template.

This is different from starting the template directly (like double clicking on
an excel file).

Since you can't get to the guts of the third party application, I think you'll
have to open the file yourself.
 
K

k.vanderstarren

Thanks again Dave. The only thing that has me puzzled is that this is
working on another system that is running Excel 2003. I'll keep poking
at it to see if I can figure something out. Cheers!
 
D

Dave Peterson

Any chance that the other program could be using an instance of excel that's
already running?
 

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