Run Time Error 1004

G

Guest

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?
 
G

Guest

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,
 
R

Roger Govier

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

runtime error code 1004 1
Run-time Error '1004' 1
run macro in another workbook - error 1004 7
Run Macro If Cell have "x" value 0
Run-time error: '1004' 4
Why this code is not work? 4
Excel Run-time error '1004' General ODBC Error 1
"Run-time error '1004' 5

Top