Macro pb in Excel worksheets inserted in Word
Macro pb in Excel worksheets inserted in Word
(OP)
I use a macro to automatically update and save an Excel workbook in *.csv type. It works perfectly for any document opened in Excel, but when I use it on an inserted object in Word, it fails...
I have a 1004 error message each time I run my macro on an Excel Worksheet object inserted in Word: the 'DisplayAlert' method from the object '_Application' has failed... I use 'Application.DisplayAlerts = False' in order not to have the confirm msgs pop ups.
How can
I have a 1004 error message each time I run my macro on an Excel Worksheet object inserted in Word: the 'DisplayAlert' method from the object '_Application' has failed... I use 'Application.DisplayAlerts = False' in order not to have the confirm msgs pop ups.
How can
Talk To Other Members
RE: Macro pb in Excel worksheets inserted in Word
You cannot save an inserted worksheet in a Word document.
You have to write a macro to save the whole Word document.
The a.m. macro should be defined in the Word document.
:)
Farzad