Excel Macro

[krangara@gmail.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..

[NickHK]

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 Word>Tools>Options>File Locations,
bizarrely it's not included in Excel's Options.
You can either set from Word or in code with:
Application.NetworkTemplatesPath=YourNetworkPathToTemplateFolder

Or possible add/edit the registry value of SharedTemplates at
HKEY_CURRENT_USER\Software\Microsoft\Office\9.0\Common\General

All this assume all your users are on a network where they can all see the
same folder somewhere.

NickHK

<krangara@gmail.com> wrote in message
news:1155780542.447185.218970@m79g2000cwm.googlegroups.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..
>

[halimnurikhwan@yahoo.com]

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 Word>Tools>Options>File Locations,
> bizarrely it's not included in Excel's Options.
> You can either set from Word or in code with:
> Application.NetworkTemplatesPath=YourNetworkPathToTemplateFolder
>
> Or possible add/edit the registry value of SharedTemplates at
> HKEY_CURRENT_USER\Software\Microsoft\Office\9.0\Common\General
>
> All this assume all your users are on a network where they can all see the
> same folder somewhere.
>
> NickHK
>
> <krangara@gmail.com> wrote in message
> news:1155780542.447185.218970@m79g2000cwm.googlegroups.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..
> >