Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macros in Personal.xls Not Accessible
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macros in Personal.xls Not Accessible
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) wrote in message ups.com... 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macros in Personal.xls Not Accessible
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macros in Personal.xls Not Accessible
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? wrote: 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 -- Dave Peterson |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macros in Personal.xls Not Accessible
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 On Sep 4, 9:24 pm, Dave Peterson wrote: 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? wrote: 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 -- Dave Peterson |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macros in Personal.xls Not Accessible
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. wrote: 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 On Sep 4, 9:24 pm, Dave Peterson wrote: 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? wrote: 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 -- Dave Peterson -- Dave Peterson |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macros in Personal.xls Not Accessible
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! On Sep 5, 3:16 pm, Dave Peterson wrote: 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. |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macros in Personal.xls Not Accessible
Any chance that the other program could be using an instance of excel that's
already running? wrote: 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! On Sep 5, 3:16 pm, Dave Peterson wrote: 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. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Macros & Personal.xls | Setting up and Configuration of Excel | |||
saving macros in personal workbook | Excel Worksheet Functions | |||
macros in personal.xls file | Excel Worksheet Functions | |||
macros in personal.xls file | Excel Worksheet Functions | |||
Excel 2003 Macros Not Accessible | Excel Discussion (Misc queries) |