#1   Report Post  
Posted to microsoft.public.word.docmanagement
cbcammarata cbcammarata is offline
external usenet poster
 
Posts: 4
Default macros

I have several Excel-linked objects (tables) in my word document, and want to
create a macro to update all objects at once. However, once I start recording
the macro, it will not allow me to right click on the object to "update
link". Anyone know how to do this?
  #2   Report Post  
Posted to microsoft.public.word.docmanagement
CyberTaz CyberTaz is offline
external usenet poster
 
Posts: 1,291
Default macros

Correct - that is expected behavior. The mouse is unusable in the document
while recording. Anything within the boundaries of the Scroll Bars, Rulers &
Status Bar are off limits. You must use the Menu commands or keyboard
equivalents. Likewise, the mouse can't be used to navigate or select text
while the recorder is active.

--
HTH |:)
Bob Jones
[MVP] Office:Mac

"cbcammarata" wrote in message
...
I have several Excel-linked objects (tables) in my word document, and want
to
create a macro to update all objects at once. However, once I start
recording
the macro, it will not allow me to right click on the object to "update
link". Anyone know how to do this?



  #3   Report Post  
Posted to microsoft.public.word.docmanagement
cbcammarata cbcammarata is offline
external usenet poster
 
Posts: 4
Default macros

ok. So, do you know how I would go about recording this macro?

"CyberTaz" wrote:

Correct - that is expected behavior. The mouse is unusable in the document
while recording. Anything within the boundaries of the Scroll Bars, Rulers &
Status Bar are off limits. You must use the Menu commands or keyboard
equivalents. Likewise, the mouse can't be used to navigate or select text
while the recorder is active.

--
HTH |:)
Bob Jones
[MVP] Office:Mac

"cbcammarata" wrote in message
...
I have several Excel-linked objects (tables) in my word document, and want
to
create a macro to update all objects at once. However, once I start
recording
the macro, it will not allow me to right click on the object to "update
link". Anyone know how to do this?




  #4   Report Post  
Posted to microsoft.public.word.docmanagement
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default macros

You wouldn't - the macro recorder's limitations would not allow such a macro
to be recorded. However what you ask is simple enough. The following should
update only the Excel links. If you want to update all the fields (links are
fields) then use the sample code at
http://www.gmayor.com/installing_macro.htm

Sub UpdateExcelLinks()
With ActiveDocument
For i = .Fields.Count To 1 Step -1
With .Fields(i)
If .Type = wdFieldLink Then
If InStr(1, .Code, "Excel") 0 Then
.Update
End If
End If
End With
Next i
.Save
End With
End Sub

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



cbcammarata wrote:
ok. So, do you know how I would go about recording this macro?

"CyberTaz" wrote:

Correct - that is expected behavior. The mouse is unusable in the
document while recording. Anything within the boundaries of the
Scroll Bars, Rulers & Status Bar are off limits. You must use the
Menu commands or keyboard equivalents. Likewise, the mouse can't be
used to navigate or select text while the recorder is active.

--
HTH |:)
Bob Jones
[MVP] Office:Mac

"cbcammarata" wrote in
message ...
I have several Excel-linked objects (tables) in my word document,
and want to
create a macro to update all objects at once. However, once I start
recording
the macro, it will not allow me to right click on the object to
"update link". Anyone know how to do this?



Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Macros have been disabled - No Macros Hugh Microsoft Word Help 2 January 14th 09 08:16 PM
Word & Enable Macros and Disable macros Theresa Microsoft Word Help 1 September 29th 08 10:38 PM
Macros Rhonda Microsoft Word Help 5 November 2nd 06 09:31 PM
With macros enabled I still receive "macros disabled" warning. Blakthorne Microsoft Word Help 6 November 1st 05 08:20 PM
macros lost in cincy Microsoft Word Help 1 March 22nd 05 04:31 PM


All times are GMT +1. The time now is 01:18 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"