Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copying macros
Dear all
I posted a question last week regarding copying macros from one workbook to another but am still stuck....... A colleague of mine wants to create several macros for the whole team to use and save them on a workbook (or several) on the server for us all to gain access to. The aim is for us to open these workbooks and be able to somehow copy the macro onto our own PC. How would we do this? Somebody suggested creating an Excel Add-In and save the macros into there but not sure what this means or how to go about it. can anybody offer any more ideas? Thank you. Louise |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copying macros
hi,
we had the same problem once and solved it this way. everyone created a personal workbook and put it in their xlstart folder on their c drive. usually it is something like c:\program files\msoffice\office\xlstart. it seems to vary depending on version. the personal file is then hidden. on the public drive, we create a folder titled bas. macros were exported to the bas folder. how? in the vb editor (alt+F11), in the project widow(far lower left) click to expand the project(file that has the macro). click to expand the project modules then right click the maro and click export. browse to the bas folder, name the macro then click save. the macro will export as a .bas file. you can also export user forms(.frm). this way users can import to their personal file only the macros they need or want. how? in the vb editor (alt+F11), in the project widow(far lower left) right click the personal project and click import. browse to the bas folder. click the ..bas file(macro) you wish to import and click open. there are other ways to handle this. this was how we did it. regards FSt1 "Louise" wrote: Dear all I posted a question last week regarding copying macros from one workbook to another but am still stuck....... A colleague of mine wants to create several macros for the whole team to use and save them on a workbook (or several) on the server for us all to gain access to. The aim is for us to open these workbooks and be able to somehow copy the macro onto our own PC. How would we do this? Somebody suggested creating an Excel Add-In and save the macros into there but not sure what this means or how to go about it. can anybody offer any more ideas? Thank you. Louise |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copying macros
Thanks for your reply. This sounds very technical! Although I do use
macros, it is only at a very basic level and some of the other users wouldn't be able to follow these instructions as they have never even created macros of their own. Do you know of any easier ways?? Louise "FSt1" wrote: hi, we had the same problem once and solved it this way. everyone created a personal workbook and put it in their xlstart folder on their c drive. usually it is something like c:\program files\msoffice\office\xlstart. it seems to vary depending on version. the personal file is then hidden. on the public drive, we create a folder titled bas. macros were exported to the bas folder. how? in the vb editor (alt+F11), in the project widow(far lower left) click to expand the project(file that has the macro). click to expand the project modules then right click the maro and click export. browse to the bas folder, name the macro then click save. the macro will export as a .bas file. you can also export user forms(.frm). this way users can import to their personal file only the macros they need or want. how? in the vb editor (alt+F11), in the project widow(far lower left) right click the personal project and click import. browse to the bas folder. click the .bas file(macro) you wish to import and click open. there are other ways to handle this. this was how we did it. regards FSt1 "Louise" wrote: Dear all I posted a question last week regarding copying macros from one workbook to another but am still stuck....... A colleague of mine wants to create several macros for the whole team to use and save them on a workbook (or several) on the server for us all to gain access to. The aim is for us to open these workbooks and be able to somehow copy the macro onto our own PC. How would we do this? Somebody suggested creating an Excel Add-In and save the macros into there but not sure what this means or how to go about it. can anybody offer any more ideas? Thank you. Louise |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copying macros
I think your best option is to create an Add-In.
Read here to get you started: http://www.fontstuff.com/vba/vbatut03.htm Do some Googling to find more help, maybe get a book that covers the topics of cretaing Add-Ins. Its not difficult at all... knut "Louise" skrev i melding ... Dear all I posted a question last week regarding copying macros from one workbook to another but am still stuck....... A colleague of mine wants to create several macros for the whole team to use and save them on a workbook (or several) on the server for us all to gain access to. The aim is for us to open these workbooks and be able to somehow copy the macro onto our own PC. How would we do this? Somebody suggested creating an Excel Add-In and save the macros into there but not sure what this means or how to go about it. can anybody offer any more ideas? Thank you. Louise |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copying macros
Thank you for your reply.
I will read the website for add-ins and see how I go. Thanks again. Louise "DS-NTE" wrote: I think your best option is to create an Add-In. Read here to get you started: http://www.fontstuff.com/vba/vbatut03.htm Do some Googling to find more help, maybe get a book that covers the topics of cretaing Add-Ins. Its not difficult at all... knut "Louise" skrev i melding ... Dear all I posted a question last week regarding copying macros from one workbook to another but am still stuck....... A colleague of mine wants to create several macros for the whole team to use and save them on a workbook (or several) on the server for us all to gain access to. The aim is for us to open these workbooks and be able to somehow copy the macro onto our own PC. How would we do this? Somebody suggested creating an Excel Add-In and save the macros into there but not sure what this means or how to go about it. can anybody offer any more ideas? Thank you. Louise |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copying macros | Excel Worksheet Functions | |||
Copying macros & tool bar | Excel Discussion (Misc queries) | |||
Macros for copying and pasting | Excel Discussion (Misc queries) | |||
Copying and PAsting using MACROS | Excel Worksheet Functions | |||
Copying a spreadsheet with macros | Excel Worksheet Functions |