Brilliant, PHV!!
Within about 5 seconds it marked the entire document and referenced each address accurately.
You deserve my unending gratitude!!!
My confidence in VB has been restored. I salute you. Please excuse my overexuberance, but I'm soooo relieved.
MacroPod, you also deserve an...
Hello MacroPod-
Thank you for your diligence on this problem and also for the detailed explanation. After reading your explanation, I feel certain that I'm taking the correct steps.
I continue to get the same error message so I'm writing to our macro developer here at work to ask whether...
Hello Macropod,
I hope that I'm not being annoying, but I want to make sure I understand. Can you tell me the steps for-
inserting the code
activating the working document
When you say "insertig the code" is that something that I haven't done already?
Does "activating the working document"...
dUgly- I think we're talking about the same thing re: Project Explorer.
Here's my tree:
Normal
Microsoft Word Objects
This Documents
Forms
cmdControl
UserForm1
Modules
NewMacros
Another indication this macro is saved under the Normal.dot is that in the title bar of the...
PH, nope the normal.dot will not be on the CD. But, once I've used the macro to insert the hyperlinks I don't need the macro any longer.
duGly-Because I work for a large firm that has done a lot of macro development, trying to look at the Project Explorer window to figure out the lay of the...
Can you give me some specific step by step instruction when you write:
"Try adding the code to the document that you want to create the hyperlinks from and running it from there."
I am in the document that I want to create the hyperlinks from, and pressing alt+F11 to open up Visual Basic...
Thanks for the reply. I don't know whether this helps, but I'm running it on-
[ul square]Windows XP Professional
Microsoft Office Word 2003 (Part of Microsoft Office Professional 2003)
Microsoft Visual Basic 6.3[/ul]
I've cursored through the code and I'm not seeing any extra spaces. Any...
Greetings Macropod-
Looks like the time for you is about 4:00am (tomorrow). I'm in California, U.S.
I looked up your holiday, ANZAC Day, so you're probably busy with the holiday.
I tried to run the code and it breaks with this error message: Compile error: expected function or variable...
Gerry, thanks for writing. Don't mean to pester you while you're on vacation. I love this site, too. I just signed up about a week ago.
I'll give you an overview of this project I'm doing. I work in a law firm. Our real estate attorneys work on large closings, each closing generating...
Wowee gazowee! I must say that my eyes are glazed over. I'm going to have to study this line by line and try to understand it. I won't be able to test your code until tomorrow when I get to work. I'll let you know how it works out.
I've had one college course on VB for Beginners. I work...
I haven't heard back from anyone and I could really and truly use the help. I am so new to programming and am struggling with where to start. I hope I haven't offended you, Gerry. You started to help me, then I lost you. I absolutely in no way meant to be offensive. I've been up and down...
I should give you some more background. Ultimately, this project will end up being saved to a CD. The CD will be set up to autoexecute and open the index of the documents. That is, the end user inserts the CD and automatically the Word index launches on screen. The end user will click on the...
Thanks for your response, Gerry. [morning]
What I'd like the macro to do is to copy the number 1 that appears before Management Agreement and paste it into the address of the hyperlink and at some point add the zeros before the number 1 and the .pdf after the 1. So ultimately, the address...
I wanted to show code I've already attempted. This code works in adding the hyperlink and correctly displays the anchor, however I'm clueless about how to change the address to match up with the filename:
Selection.Find.ClearFormatting
With Selection.Find
.Text = "^p^#"...
I must admit that I'm very green at programming and this may seem like a simple problem.
I have an index of documents in MS Word 2003 which are in a numbered list. I'd like to create a macro to go to each numbered document, select the document, and insert a hyperlink that references the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.