Hi Experts:

I am trying to sent a Workbook with Macros in email to other team members.
I did a test to myself in email and when I try to open the file and use the
shortcut key to run the macro, I get the 1004 Run Time Error. If I save it
to my desktop, it will run as it should. Is there something I can do so that
it will run the macro when the workbook is opened from the email?
--
jeannie v

Please post the code and maybe we can help.

"jeannie v" wrote:

Hi Experts:

I am trying to sent a Workbook with Macros in email to other team members.
I did a test to myself in email and when I try to open the file and use the
shortcut key to run the macro, I get the 1004 Run Time Error. If I save it
to my desktop, it will run as it should. Is there something I can do so that
it will run the macro when the workbook is opened from the email?
--
jeannie v

Hi Barb:

This is what is states:

Run-time error '1004':
'CPH.TPA.Marquez.MACRO TEMPLATE.xls' could not be found

However, if I move it to the Desktop, it will run correctly.

Thanks for your help,
--
jeannie v


"Barb Reinhardt" wrote:

Please post the code and maybe we can help.

"jeannie v" wrote:

Hi Experts:

I am trying to sent a Workbook with Macros in email to other team members.
I did a test to myself in email and when I try to open the file and use the
shortcut key to run the macro, I get the 1004 Run Time Error. If I save it
to my desktop, it will run as it should. Is there something I can do so that
it will run the macro when the workbook is opened from the email?
--
jeannie v

Hi Jeannie

If you are mailing a report generated from the Template, the report will
be an XLS file and will not contain the Code that exists in the
Template.
It runs from your Desktop, because it can find the .XLT file on your
machine, and can thus execute the Code.

Are you mailing the XLT file or an XLS file?

--
Regards

Roger Govier


"jeannie v" wrote in message
...
Hi Barb:

This is what is states:

Run-time error '1004':
'CPH.TPA.Marquez.MACRO TEMPLATE.xls' could not be found

However, if I move it to the Desktop, it will run correctly.

Thanks for your help,
--
jeannie v


"Barb Reinhardt" wrote:

Please post the code and maybe we can help.

"jeannie v" wrote:

Hi Experts:

I am trying to sent a Workbook with Macros in email to other team
members.
I did a test to myself in email and when I try to open the file and
use the
shortcut key to run the macro, I get the 1004 Run Time Error. If I
save it
to my desktop, it will run as it should. Is there something I can
do so that
it will run the macro when the workbook is opened from the email?
--
jeannie v