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/