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 cowski on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Macro pb in Excel worksheets inserted in Word

  • Thread starter Thread starter -
  • Start date Start date
Status
Not open for further replies.

Guest
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
 
Sort by date Sort by votes
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
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Bheem369
  • Locked
  • Question Question
MACRO TO CREATE CLOSE SURFACE FROM STYLING SURFACE IN CATIA
Replies
2
Views
2K
Bheem369
Bheem369
blackeng1660
  • Locked
  • Question Question
Error macro which multiple coincidence assemblies fastly
Replies
0
Views
883
blackeng1660
blackeng1660
Windchill Creo
  • Locked
  • Question Question
Need to check the State of existing files in PDM(Winchill) +Creo
Replies
0
Views
338
Windchill Creo
Windchill Creo
JoelTXCive
  • Locked
  • Question Question
Excel VBA - Printing Code in Color?
Replies
0
Views
1K
JoelTXCive
JoelTXCive
jeannier1975
  • Locked
  • Question Question
I may be in the wrong place, excuse
Replies
4
Views
1K
IRstuff
IRstuff

Part and Inventory Search

Sponsor

Back
Top