how do I email amacro?

[Guest]

Ok, I did that. Should the receipient put in in the xlstart folder so it
opens when he opens xl and thereby will function? If not, how does the user
apply the macro file to a newly downloaded file?

thx,

Please don't send the macro as text to the other users. If you think you're
having trouble exporting the modules so you can send them, imagine the phone
calls you'll get from each of the recipients when they receive your file.

Open the workbook with all those macros
save it as a new name--just in case!
Delete the modules you don't want.
Delete the data you don't want.
Save the file once more.

Send that file.

 

[Dave Peterson]

It's the end user's choice (with your recommendation).

Personally, I wouldn't put it in XLStart. I only want things that are really
useful to all workbooks in that location.

If your routines are generic enough to be useful with every worksheet, then put
them there.

If your routines are specific to that downloaded data, I'd just tell the user to
open the file with the macros when they need them.

But the choice is yours (or the end users).

Ok, I did that. Should the receipient put in in the xlstart folder so it
opens when he opens xl and thereby will function? If not, how does the user
apply the macro file to a newly downloaded file?

thx,

 

[Guest]

When I rename a new macro workbook by deleteing all other macros except the
on eI want, put the macro in xlstart and then open the data file and run the
macro it works fine. So thanks I can email a macro. When I do not put the
macro in xlstart but import thr data into the new macroworkbook it reformats
the data incorrectly. I don't understand it is the same macro

It's the end user's choice (with your recommendation).

Personally, I wouldn't put it in XLStart. I only want things that are really
useful to all workbooks in that location.

If your routines are generic enough to be useful with every worksheet, then put
them there.

If your routines are specific to that downloaded data, I'd just tell the user to
open the file with the macros when they need them.

But the choice is yours (or the end users).

 

[Dave Peterson]

I'd guess that you did something wrong--or even ran the macro against the wrong
worksheet--or ran it twice???

But those are just guesses.

When I rename a new macro workbook by deleteing all other macros except the
on eI want, put the macro in xlstart and then open the data file and run the
macro it works fine. So thanks I can email a macro. When I do not put the
macro in xlstart but import thr data into the new macroworkbook it reformats
the data incorrectly. I don't understand it is the same macro

It's the end user's choice (with your recommendation).

Personally, I wouldn't put it in XLStart. I only want things that are really
useful to all workbooks in that location.

If your routines are generic enough to be useful with every worksheet, then put
them there.

If your routines are specific to that downloaded data, I'd just tell the user to
open the file with the macros when they need them.

But the choice is yours (or the end users).

 

[Guest]

I'll work on it. Thanks for all your help

I'd guess that you did something wrong--or even ran the macro against the wrong
worksheet--or ran it twice???

But those are just guesses.