Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
isolate macros
I have a excel file and in it a series of Macros. Let's call it
main.xls Right now I run a form that executes all the macros from that file. (main.xls) The file is used by someone else who enters data to it daily. so when I need to modify the macro I have to merge my changes with the file he is modifying. this is becoming a problem since I plan on making many other modifications in the newar future what would be the best way to seperate the two? I could have a seperate file (call this one execute.xls) with all the macros and launch my form from that new file. So if I need to modify any macro I don't need the updated main.xls file. is there a better way? another option that came to mind is to make a small app in VB..how easy would it be to make it an app that could execute the macros and modify the xls files?? any help here would be great thanks Pabs --- Message posted from http://www.ExcelForum.com/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
isolate macros
Hi Pabs
It's very difficult to modify and update your macros, if they're in a shared workbook. There's a very useful method, which is called "Add-In". All you have to do is, put your makros in a worksheet and save it to a shared path as an Add-In. After that, install the Add-In both on the machines. That's all. --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
isolate macros
how can you call a macro from another worksheet once it has been
installed as an add-in? --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there a way to isolate individual cells? | Excel Worksheet Functions | |||
isolate numbers in a cell | New Users to Excel | |||
how do I isolate cells to not print | New Users to Excel | |||
Isolate text following a period (".") | Excel Worksheet Functions | |||
How to Isolate macros from different Workbooks? | Excel Programming |