Macro pb in Excel worksheets inserted in Word

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

 

[FH]

Dear schwob,
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