Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Macro pb in Excel worksheets inserted in Word

Status
Not open for further replies.
schwob

schwob

Technical User
Aug 27, 2002
7
FR
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 make my macro work in any case?
 
Status
Not open for further replies.

Similar threads

remeng
  • Locked
  • Helpful tip
Microsoft Office 365 Word Macro Causing a Project is unviewable error
Replies
1
Views
293
dhookom
dhookom
K
  • Locked
  • Question
How to resolve define worksheets array
Replies
1
Views
310
combo
combo
remeng
  • Locked
  • Solved
Combine two working macros into one for MS Word 1
Replies
7
Views
497
strongm
strongm
remeng
  • Locked
  • Solved
Run-time error '429': ActiveX component can't create object From Excel to Word
Replies
9
Views
556
remeng
remeng
sal21
  • Question
scrping in listbox in a web page
Replies
0
Views
187
sal21
sal21

Part and Inventory Search

Sponsor

Back
Top