Excel Workbook with digitally signed macro (important?)
The primary execution of the macro in the Excel workbook following the embedding of
the Excel workbook works, after saving, closing, and re-opening the document the secondary execution of the macro fails.
The macro copies values from a data entry sheet, to a chart data sheet,
and revises the chart with the new data.
Process Detail:
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: [filename of document]'
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
Has anyone run into this?
Have you been able to solve it?