| | |
I need help using VBA for Word Macros
![]() |
•
•
Join Date: Jul 2003
Posts: 22
Reputation:
Solved Threads: 0
I have a document that needs to be filled out. To help the user input all the correct information that goes on the form, I built a user form. On enter, the information gets transferred to the form. To accomplish this I use this statements like the ones below:
ActiveDocument.Bookmarks("NAME").range.InsertBefore txtName
ActiveDocument.Bookmarks("ADDRESS").range.InsertBefore txtAddress
This works great because I have separate bookmarks for Name and Address. But, what if I just have one bookmarks called "DATA":
ActiveDocument.Bookmarks("DATA").range.InsertBefore txtNetWeight _
& vbTab & txtCostPerLbs & vbCrLf
After this gets put on the document, I ask the users if he needs to input data again. If he clicks on Yes, then:
ActiveDocument.Bookmarks("DATA").range.InsertBefore txtNetWeight _
& vbTab & txtCostPerLbs & vbCrLf
BUT, here's the problem. I need the second set of data to be inserted below the first line that is already on the document. What happens instead is that it gets inserted above the line that is already on the document.
Any ideas? :roll:
ActiveDocument.Bookmarks("NAME").range.InsertBefore txtName
ActiveDocument.Bookmarks("ADDRESS").range.InsertBefore txtAddress
This works great because I have separate bookmarks for Name and Address. But, what if I just have one bookmarks called "DATA":
ActiveDocument.Bookmarks("DATA").range.InsertBefore txtNetWeight _
& vbTab & txtCostPerLbs & vbCrLf
After this gets put on the document, I ask the users if he needs to input data again. If he clicks on Yes, then:
ActiveDocument.Bookmarks("DATA").range.InsertBefore txtNetWeight _
& vbTab & txtCostPerLbs & vbCrLf
BUT, here's the problem. I need the second set of data to be inserted below the first line that is already on the document. What happens instead is that it gets inserted above the line that is already on the document.
Any ideas? :roll:
Well, I'm a VB.NET developer, and I don't really know much about VBA with MS Word, but, why not try creating a new bookmark at the end of your inserted portion, and then insert at that new bookmark?
You could then have an unlimited amount of inserts without a problem.
You could then have an unlimited amount of inserts without a problem.
-Ryan Hoffman
.NET Specialist / Webmaster, Extended64.com.
Please do not email or PM me with support questions. Please direct them to the forums instead.
.NET Specialist / Webmaster, Extended64.com.
Please do not email or PM me with support questions. Please direct them to the forums instead.
•
•
Join Date: Jul 2003
Posts: 22
Reputation:
Solved Threads: 0
Thanks for the reply. I actually received some help yesterday from a different source, Martin Green's Office Tips, and my problem is now solved. You were correct in your suggestion. Here's what Mr. Green suggested:
Dim DataRange As Range
Set DataRange = ActiveDocument.Bookmarks("Data").Range
If DataRange = "" Then
DataRange = "Some Text"
Else
DataRange = DataRange & " " & "More Text"
End If
ActiveDocument.Bookmarks.Add "Data", DataRange
Where I have written "Some Text" and "More Text" you can substitute with you textbox names. My example puts a space between the insertions. You could puta line break instead:
DataRange = DataRange & vbCrLf & "More Text"
I think that would work
Dim DataRange As Range
Set DataRange = ActiveDocument.Bookmarks("Data").Range
If DataRange = "" Then
DataRange = "Some Text"
Else
DataRange = DataRange & " " & "More Text"
End If
ActiveDocument.Bookmarks.Add "Data", DataRange
Where I have written "Some Text" and "More Text" you can substitute with you textbox names. My example puts a space between the insertions. You could puta line break instead:
DataRange = DataRange & vbCrLf & "More Text"
I think that would work
![]() |
Similar Threads
- Help with VBA Word Bookmarks (Windows NT / 2000 / XP)
- Macros in Word 2007 (Visual Basic 4 / 5 / 6)
- Export/Import problem in VBA Word (Visual Basic 4 / 5 / 6)
- Programming VBA: Reading excel into an Array (Visual Basic 4 / 5 / 6)
- Word Macros (Computer Science)
- Need To Print PDF using VBA in Word (Visual Basic 4 / 5 / 6)
Other Threads in the Windows NT / 2000 / XP Forum
- Previous Thread: New Hardware Causing Error
- Next Thread: How To Tweak Icon Sizes and so,Windows XP Startbar
| Thread Tools | Search this Thread |
.net 3.5 3daccelertion 64bit 2010 activedirectory alaris android application arm auto black blue book boot bsod bulletin canonical cellphones chinese codeplex collaboration combofix computer computerfreezes deployments desktop domain drive dual error explorer fax fonts freeze gadgets hardware home install intel killprocess laptop laptops latitude lcd linux load mac markshuttleworth memory microsoft minimalizes mobile monitor netbooks opensource operatingsystems options oracle osinstallationproblem outlook partition patch port program proxy raid rds reformat remotedesktopconnection retail screen security server. sitetositevpn slowperformance sp1 sp3 spyware studios technology ubuntu uninstall unreadable update upgrade usb verizon virtual virus vpn wab webos weecam window windows windows7 windowsxp worm xp





