Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error when opening Embedded Excel File in Word
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error when opening Embedded Excel File in Word
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. " wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
AciveWindow.ScrollColumn / Excel file embedded in word | Excel Programming | |||
Editing embedded Word file in Excel JUMPS to top | Excel Discussion (Misc queries) | |||
Problem opening Excel file 1 time with embedded Word objects | Excel Programming | |||
error excel if embedded in word documents | Excel Programming | |||
Excel file embedded in Word doc--limitations of work area | Excel Programming |