There are no modules in a CSV file so can't tell what you're doing.


Gord

On Thu, 01 Oct 2009 19:24:11 GMT, "BNT1 via OfficeKB.com" <u19326@uwe
wrote:

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