Hello All,
I'm trying to put together a macro that will clean a spreadsheets prior to
it being saved in a CSV file format. I need to remove the £ % , from the
spreadsheet.

My problem is that I want to access the spreadsheet from my spreadsheet
rather than adding the macro to each of the spreadsheets I'm dealing with.

Hope this makes sense.

Thanks
David

Put the macro in the Personal.xls file, and it will be generally available.

--
HTH

Bob Phillips

"David Goodall" wrote in message
...
Hello All,
I'm trying to put together a macro that will clean a spreadsheets prior to
it being saved in a CSV file format. I need to remove the £ % , from the
spreadsheet.

My problem is that I want to access the spreadsheet from my spreadsheet
rather than adding the macro to each of the spreadsheets I'm dealing with.

Hope this makes sense.

Thanks
David

In your macro, use references/qualifiers like
ActiveSheet
ActiveWorkbook
ActiveCell

Then the macro will work on the sheet that has the focus. It doesn't matter
that the code is located in a different workbook (as long as the workbook
with the code is also open).

--
Regards,
Tom Ogilvy


"David Goodall" wrote in message
...
Hello All,
I'm trying to put together a macro that will clean a spreadsheets prior to
it being saved in a CSV file format. I need to remove the £ % , from the
spreadsheet.

My problem is that I want to access the spreadsheet from my spreadsheet
rather than adding the macro to each of the spreadsheets I'm dealing with.

Hope this makes sense.

Thanks
David