![]() |
#1
|
|||
|
|||
![]()
As following, I have written a macro to automate Cross Referencing to Word Curves. When I running the macro, It encounter “Run-time error 4198,. Command failed”, Can anybody Guides me on this issue? (When I first wrote this macro, It worked for a While, But then stopped working)
Sub crosscurve() Selection.InsertCrossReference ReferenceType:="curve", ReferenceKind:= _ wdOnlyLabelAndNumber, ReferenceItem:=InputBox("what is the number of curve do you want to refer?"), InsertAsHyperlink:=True, _ IncludePosition:=False, SeparateNumbers:=False, SeparatorString:=" " End Sub Last edited by soroush.kalantari; 04-18-2022 at 04:24 AM. |
#2
|
||||
|
||||
![]()
Multiple issues:
1. There is no such thing as a "curve" Reference Type. See: Selection.InsertCrossReference method (Word) | Microsoft Docs WdReferenceType Enum (Microsoft.Office.Interop.Word) | Microsoft Docs WdCaptionLabelID Enum (Microsoft.Office.Interop.Word) | Microsoft Docs 2. You're missing the required quite characters & line continuation characters here: Code:
number of curve " & _ "do you
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
![]() Quote:
|
#4
|
||||
|
||||
![]()
Your code works on my machine although I did change it to separate the inputbox out
Code:
Sub crosscurve() Dim str As String str = InputBox("what is the number of curve do you want to refer?") Selection.InsertCrossReference ReferenceType:="curve", ReferenceKind:=wdOnlyLabelAndNumber, _ ReferenceItem:=str, InsertAsHyperlink:=True, _ IncludePosition:=False, SeparateNumbers:=False, SeparatorString:=" " End Sub 1. The existence of a 'Curve' caption is at the application level. The presence of some curve instances in a document brought from another machine is not enough to tell Word that the type exists. Have you inserted at least one Curve caption on that machine? 2. Is it sensitive to capitalisation?
__________________
Andrew Lockton Chrysalis Design, Melbourne Australia |
#5
|
|||
|
|||
![]() Quote:
|
#6
|
||||
|
||||
![]()
Ahh, that would likely be caused when you add a caption to a floating (text wrapped) object rather than an inline one.
__________________
Andrew Lockton Chrysalis Design, Melbourne Australia |
#7
|
|||
|
|||
![]()
Ok. I got the point. Thank you very much.
|
![]() |
Tags |
cross referencing |
Thread Tools | |
Display Modes | |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
Rayroshi | Word VBA | 4 | 09-06-2020 06:28 PM |
How to write macro | yoyo4 | Excel Programming | 1 | 11-19-2017 11:43 PM |
Macro: automate a contract? | 1questionman | Word VBA | 3 | 10-17-2017 08:29 PM |
Macro to automate changes to slide | Mearsy | PowerPoint | 0 | 08-18-2015 03:29 AM |
![]() |
mkoenig | Word VBA | 1 | 01-31-2010 02:47 AM |