Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Macro
how can I move all the macro code to one single location from the excel
template. Basically this what i need to accomplish. Currently my excel template has all the codes/macros . Everytime I change the macro code, I need to send out the new template to everyone on the group as a new version. Is there a way where i can simply change my macro code in one location, and template always look at this place.. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Macro
If everyone sets their "Workgroup Templates" to the same path, then they
will see the same single version of your template each time. This is an Office wide setting. Whilst this setting is available in the WordToolsOptionsFile Locations, bizarrely it's not included in Excel's Options. You can either set from Word or in code with: Application.NetworkTemplatesPath=YourNetworkPathTo TemplateFolder Or possible add/edit the registry value of SharedTemplates at HKEY_CURRENT_USER\Software\Microsoft\Office\9.0\Co mmon\General All this assume all your users are on a network where they can all see the same folder somewhere. NickHK wrote in message oups.com... how can I move all the macro code to one single location from the excel template. Basically this what i need to accomplish. Currently my excel template has all the codes/macros . Everytime I change the macro code, I need to send out the new template to everyone on the group as a new version. Is there a way where i can simply change my macro code in one location, and template always look at this place.. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Macro
Hi,
Do you mean move or copy the codes... if you just want to copy why you dont use export code module ? like this: Sub exportmodule() ThisWorkbook.VBProject.VBComponents _ ("module1").Export "C:\ExportedFile.bas" End Sub look at c:\ tks Halim NickHK menuliskan: If everyone sets their "Workgroup Templates" to the same path, then they will see the same single version of your template each time. This is an Office wide setting. Whilst this setting is available in the WordToolsOptionsFile Locations, bizarrely it's not included in Excel's Options. You can either set from Word or in code with: Application.NetworkTemplatesPath=YourNetworkPathTo TemplateFolder Or possible add/edit the registry value of SharedTemplates at HKEY_CURRENT_USER\Software\Microsoft\Office\9.0\Co mmon\General All this assume all your users are on a network where they can all see the same folder somewhere. NickHK wrote in message oups.com... how can I move all the macro code to one single location from the excel template. Basically this what i need to accomplish. Currently my excel template has all the codes/macros . Everytime I change the macro code, I need to send out the new template to everyone on the group as a new version. Is there a way where i can simply change my macro code in one location, and template always look at this place.. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
My excel macro recorder no longer shows up when recording macro | Excel Discussion (Misc queries) | |||
Need syntax for RUNning a Word macro with an argument, called from an Excel macro | Excel Programming | |||
translate lotus 1-2-3 macro into excel macro using excel 2000 | Excel Programming | |||
Excel Macro Issue Trying to autorun Macro Upon Opening Worksheet | Excel Programming |