distributing macros

Mar 5th, 2002, 02:10 PM

Here's what I have:
-Business software that users can run canned queries on and it exports to excel.
-This launches excel each time an export happens.
-The reports are not formatted or parsed.
-the reports always have a different name when exported (i.e. xxxxxxxxxx.txt)
What I have done:
--created macros to format certain reports.
What I'd like to do:
--share these macros with users. What is the best way to do this? I've created menu items with the individual report macros set up...how to share with users?
Help would be appreciated!

NateO · Mar 5th, 2002, 04:59 PM

I like e-mail for electronic correspondence. Perhaps distribute the file via e-mail.

Cheers, Nate

[ This Message was edited by: NateO on 2002-03-05 15:59 ]

Ivan F Moala · Mar 6th, 2002, 01:41 AM

Create the file as an addin.

Lookup online help or goto MS for further
help.

Ivan

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 5th, 2002, 02:10 PM	#1
Guest Posts: n/a	Here's what I have: -Business software that users can run canned queries on and it exports to excel. -This launches excel each time an export happens. -The reports are not formatted or parsed. -the reports always have a different name when exported (i.e. xxxxxxxxxx.txt) What I have done: --created macros to format certain reports. What I'd like to do: --share these macros with users. What is the best way to do this? I've created menu items with the individual report macros set up...how to share with users? Help would be appreciated!

Mar 5th, 2002, 04:59 PM	#2
NateO Legend Join Date: Feb 2002 Location: Minneapolis, Mn, USA Posts: 9,704	I like e-mail for electronic correspondence. Perhaps distribute the file via e-mail. Cheers, Nate [ This Message was edited by: NateO on 2002-03-05 15:59 ]

Mar 6th, 2002, 01:41 AM	#3
Ivan F Moala MrExcel MVP Join Date: Feb 2002 Location: Auckland, New Zealand Posts: 4,209	Create the file as an addin. Lookup online help or goto MS for further help. Ivan