| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro links to other workbooks
I've exported several macros to be imported into other workbooks when they
are first used. When a macro is imported it retains the link to the original workbook. How do I remove the links? It's likely I'm missing somehting obvious but I'm lost for looking. -- Jim |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro links to other workbooks
Correction: they aren't linked to the original workbook. It's the name of
thisworkbook. When I write a macro that creates the buttons, I can't put thisworkbook.name in the "OnAction" command. -- Jim "Jim G" wrote: I've exported several macros to be imported into other workbooks when they are first used. When a macro is imported it retains the link to the original workbook. How do I remove the links? It's likely I'm missing somehting obvious but I'm lost for looking. -- Jim |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro links to other workbooks
This kind of thing works for me:
..OnAction = "'" & ThisWorkbook.Name & "'!" & "somemacronamehere" Jim G wrote: Correction: they aren't linked to the original workbook. It's the name of thisworkbook. When I write a macro that creates the buttons, I can't put thisworkbook.name in the "OnAction" command. -- Jim "Jim G" wrote: I've exported several macros to be imported into other workbooks when they are first used. When a macro is imported it retains the link to the original workbook. How do I remove the links? It's likely I'm missing somehting obvious but I'm lost for looking. -- Jim -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro links to other workbooks
Thanks Dave, worked perfectly. The double quotes and apostrophe's get me
every time! -- Jim "Dave Peterson" wrote: This kind of thing works for me: ..OnAction = "'" & ThisWorkbook.Name & "'!" & "somemacronamehere" Jim G wrote: Correction: they aren't linked to the original workbook. It's the name of thisworkbook. When I write a macro that creates the buttons, I can't put thisworkbook.name in the "OnAction" command. -- Jim "Jim G" wrote: I've exported several macros to be imported into other workbooks when they are first used. When a macro is imported it retains the link to the original workbook. How do I remove the links? It's likely I'm missing somehting obvious but I'm lost for looking. -- Jim -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to open, Update links, save and close workbooks | Excel Discussion (Misc queries) | |||
| Slow opening links between workbooks with links created in 2003 | Excel Discussion (Misc queries) | |||
| Updating Workbooks from multiple links Workbooks | Excel Worksheet Functions | |||
| Macro to copy from workbooks listed as http links | Excel Programming | |||
| Update links to other workbooks while running macro | Excel Programming | |||
Linear Mode
