Workbook w/Macro Embedded within Word: Macro fails to execute (more see description)

ABHale

New Member
Joined
Sep 13, 2008
Messages
6
Excel Workbook with digitally signed macro (important?)

Workbook in Excel
- Macro works as expected

Embed workbook in Word

Enter Excel, change data, run macro, exit Excel
Enter Excel, change data, run macro, exit Excel
Enter Excel, change data, run macro, exit Excel
....

Save Word document
Exit Word
Start Word
Open document

Enter Excel, change data, run macro, get message:

Microsoft Office Excel cannot access the file 'Worksheet in C:<open document name>'
There are several possible reasons:

The filename or path does not exist.
The file is being used by another program.
The workbook you are trying to save has the same name as a currently open workbook.

Excel and Word are 2007

I'm I doing something wrong or is this a bug in a tux? (An unintended feature?)
 

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.
Resolved: The button I was using to execute the macro was a Form button, when I changed it to an ActiveX button the problem went away. :confused:
 
Upvote 0

Forum statistics

Threads
1,214,832
Messages
6,121,841
Members
449,051
Latest member
excelquestion515

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top