Thank you all for the input

this is the code i am using (recorded macro), copied it in CSV module
I open the email attachment and use the shortcut, however, it keeps asking to
update the file and shows all folders
Can / should this be run direct from the email or do i have to save first?

regards

Gord Dibben wrote:
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

Hi

[quoted text clipped - 8 lines]

Brian

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200910/1