Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #5  
Old 04-18-2022, 08:35 PM
soroush.kalantari soroush.kalantari is offline How to Write a macro to automate Cross Refrenceing? Windows 10 How to Write a macro to automate Cross Refrenceing? Office 2016
Competent Performer
How to Write a macro to automate Cross Refrenceing?
 
Join Date: Jun 2021
Posts: 124
soroush.kalantari is on a distinguished road
Default

Quote:
Originally Posted by Guessed View Post
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
The things I would expect would cause it to fail are:
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?
Thank you for your reply. I have found the issue. This code fails because when I insert a caption for my Word curves, sometimes unexpectedly a textbox which is without border and outline and color encompasses the captions. If I solve this problem, I can cross -reference my word curves with this code again.
Reply With Quote
 

Tags
cross referencing



Similar Threads
Thread Thread Starter Forum Replies Last Post
How to Write a macro to automate Cross Refrenceing? Can I write a macro in which I Use the Mouse? 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
How to Write a macro to automate Cross Refrenceing? Can I automate or make a macro for this? mkoenig Word VBA 1 01-31-2010 02:47 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:41 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft