Distribute Excel Macros OR better way???

[tweetyksc]

I am going crazy re this.
I have reports that come off our system unformatted, and launch a new excel session with the data in .txt format. Needs to be parsed/formatted, etc. before printing.
I have created macros that I use to automate this; other than running everyone's reports for them, what is the best way to send these macros so they can use the automation on their own pcs? There will be numerous macros. I want to do this efficiently, and make updating/adding efficient too.
I apologize for duplicate posts but I'm getting desperate here.

 

[kilroyscarnival]

Depending on your setup...if you are creating all your macros in your Personal Macro Workbook, and providing your colleagues don't have macros of their own, couldn't you just send them your Personal Macro Workbook periodically and instruct them to save it? The location would be
"c:\program files\microsoft office\office\xlstart\personal.xls"

Alternatively, I think they can have two hidden workbooks in XLStart, so just make it Personal2.xls and have them put it in the XLStart folder, and keep Hidden.

Would that work?

--Ann

 

[tweetyksc]

Thanks for the suggestion.
That seems like the most "foolproof" way of doing it. Maybe I can send the macro workbook with a macro to save it (I can imagine getting all kinds of questions on where to save it, what to call it, even if I spell it out--you know the drill).
I'm going to try that and see how it goes.
Now I just have to finalize all the macros!

 

[tweetyksc]

One other thing...now that I've decided to do it the way you suggested...
what's the easiest way to send them the macros AND have it show up on a menu everytime they bring up excel?
I know how to create menus but I seem to be having trouble attaching them.
I want all users to have an extra menu with all the macros in the drop down menu so they can run by point and click. I want the menu to always be on their menu bar when they launch Excel.

 

[kilroyscarnival]

That's a very good question (about transferring the menu items) and one I don't know about. I thought those properties were resident in the program files, rather than workbook files, and I don't know how to efficiently transfer them to other users. Hopefully someone else can chime in on that.

--Ann