Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change default path to personal macros
Good evening;
I removed MS Office 2002 and installed Office 2003. My assigned macros are still pointing to Office 10 xlstart instead of Office 11. How do I change the path so it will find my assigned macros? Thanks Phil |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change default path to personal macros
Tom Ogilvy just posted this from Bernie Deitrick.
===== Adjust this code posted previously by Bernie Deitrick to replace wrong path with the right path JB, Try running the macro below to change the link from the .xls to the .xla file. You can also change the path by modifying the code, but as written this assumes both files are in the same folder. HTH, Bernie MS Excel MVP Sub RepairUserDefinedButtons3() Dim CmdBar As CommandBar Dim i As Integer On Error GoTo ErrorReading: For Each CmdBar In CommandBars For i = 1 To CmdBar.Controls.Count If CmdBar.Controls(i).BuiltIn = False Then If InStr(1, CmdBar.Controls(i).OnAction, _ "my-macros.xls") Then CmdBar.Controls(i).OnAction = _ Replace(CmdBar.Controls(i).OnAction, _ "my-macros.xls", "my-macros.xla") End If End If ErrorReading: Next i Next CmdBar End Sub -- Regards, Tom Ogilvy AuthorizedUser wrote: Good evening; I removed MS Office 2002 and installed Office 2003. My assigned macros are still pointing to Office 10 xlstart instead of Office 11. How do I change the path so it will find my assigned macros? Thanks Phil -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change default document path for all programs in Office Suite? | Excel Discussion (Misc queries) | |||
Change default path for assigning macros | Setting up and Configuration of Excel | |||
change default file path in Save As dialog box | Excel Programming | |||
Can I change ExCels default save path for saving add-ins ? | Excel Programming | |||
Personal.XLS path problem | Excel Programming |