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

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

I do not fully understand your issue here, but you cannot save the macro in
..csv file (if that is what your trying to do).

-kc
*Click YES if this works

"BNT1 via OfficeKB.com" 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

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

Macros live in excel workbooks--not CSV files.

So if you want the recipient to be able to use your macro, you could create a
separate workbook that contains that macro that processes the CSV data.

Then send both the workbook and the .csv file to the recipient. (Maybe just the
macro workbook one time and tell them to save it and re-open it when they need
it.)

Then tell them to open the workbook with the macro (and depending on what your
macro does), then tell them to save/open the csv file and run the macro
(tools|macro|macros...|run in xl2003 menus).

"BNT1 via OfficeKB.com" 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

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

--

Dave Peterson

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

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

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

it has excel in the top right hand corner
will take another look at when at work in the morning and try and get more
info

regards



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

Gord

Thank you all for the input

[quoted text clipped - 21 lines]

Brian

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

Hi

I have misunderstood, and it is an excel file. When generating the report,
from AS400 system tne file is an attachement and a sheet name is allocated
each time it is run, ie, `OASISCSV(48). then next time `OASISCSV(49) etc.
This stopped the macro running owing to the sheet name when i defined a range.
It does run if i amend the sheet name to sheet1.
Is there an way of giving it any wild cards etc, say OASISCSV**** or
something, in the macro, to prevent it looking for the sheet1. Also the
shortkut cut does not operate, but selecting from tools/macro does?

All help is appriciated

Brian


BNT1 wrote:
it has excel in the top right hand corner
will take another look at when at work in the morning and try and get more
info

regards

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

[quoted text clipped - 5 lines]

Brian

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