You do not have to copy/paste into an Excel workbook, simply open the *.csv
attachment with Excel.

You must code your macro in your Personal Macro Workbook to operate on
whichever *.csv file you have opened in Excel.

If you open the *.csv file in Notepad or Word, your Personal Macro Workbook
is not available.


Gord Dibben MS Excel MVP

On Tue, 29 Sep 2009 19:29:39 GMT, "BNT1 via OfficeKB.com" <u19326@uwe
wrote:

Hi

I have recorded a personal macro, with a short cut key in excel. When I am
sent an e-mail with attachment, the attachment .csv file. I open the file on
the attachment, but the short cut key does not run the macro, unless, i copy
and paste into an excel doc

is it possible to get around having to copy and paste?

regards

Brian