I want to record a macro in excel but use it in different workbooks. I
export data from a webpage and want to write a macro that I can use
when I export the data to a workbook.

I recorded a macro but it only lets me save it in a workbook.

I also want to be send the macro to others so they can use it for the
same purpose.

All assistance is greatly appreciated.

hi
in order to run a macro, the macro must be in an open workbook. you can run
the macro in other workbooks not neccessarilly in the workbook in which it
resides.
most people put their personal macros in a workbook named personal.xls and
put it in the xl start folder so that it will open when excel opens. the
personal file is usually hidden but all macro would be available to run in
any file. and this file can be distributed.
if you are having trouble with your recorded macro, it may be that you are
references a specific workbook or worksheet or maybe you haven't got the
technique down yet. post your code.

Regards
FSt1
"japc90" wrote:

I want to record a macro in excel but use it in different workbooks. I
export data from a webpage and want to write a macro that I can use
when I export the data to a workbook.

I recorded a macro but it only lets me save it in a workbook.

I also want to be send the macro to others so they can use it for the
same purpose.

All assistance is greatly appreciated.