Error when opening Embedded Excel File in Word

D

doodles82a

My workbook works fine. However, after I embed my workbook, as an
object, in a word document, my attempt to open my workbook yields an
error when I respond in the affirmative to enable macros. The error is
as follows:

Error # 1004 was generated by VBA Project method 'Calculation' of
Object '_Application' failed.

Once I press the OK button, the application seems to work fine. What's
causing the error? I'd like to alleviate the issue that is causing the
error to avoid confusion for other users.

Thank you!

Michael
 
J

Joel

Because you are getting an error without doing anything an Event trigger
macro is failing. It is probably in a Wrokbook Open Event which would be
located in the THISWORKBOOK module of the Excel workbook. without seeing a
macro code I can't tell what the solution would be.
 

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

error 1004 6
EX2007 - Error 1004: method 'VBProject' of object '_Workbook' failed 15
Loosing VBA project when opening up Excel 2007 7
run macro in another workbook - error 1004 7
Code execution is correct but generates Error :The file you aretrying to open is in a different form 3
Check if Excel workbook is open via Word VBA, if open how to close it? 0
Rnd() 1004 error 6
Error 1004 opening workbook 1004 2

Top