User Name Password Register
DaniWeb IT Discussion Community
All
What is DaniWeb IT Discussion Community?
You're currently browsing the Windows NT / 2000 / XP / 2003 section within the Tech Talk category of DaniWeb, a massive community of 391,556 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,661 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our Windows NT / 2000 / XP / 2003 advertiser:
Views: 5839 | Replies: 2
Reply
Join Date: Jul 2003
Posts: 22
Reputation: I_Byte is an unknown quantity at this point 
Rep Power: 6
Solved Threads: 0
I_Byte I_Byte is offline Offline
Newbie Poster

I need help using VBA for Word Macros

  #1  
Aug 6th, 2003
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:
AddThis Social Bookmark Button
Reply With Quote  
Join Date: Feb 2002
Location: New York
Posts: 862
Reputation: Tekmaven is a glorious beacon of light Tekmaven is a glorious beacon of light Tekmaven is a glorious beacon of light Tekmaven is a glorious beacon of light Tekmaven is a glorious beacon of light 
Rep Power: 12
Solved Threads: 15
Moderator
Tekmaven's Avatar
Tekmaven Tekmaven is offline Offline
The C# Man, Myth, Legend

Re: I need help using VBA for Word Macros

  #2  
Aug 6th, 2003
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.
-Ryan Hoffman

ASP.NET Specialist / Webmaster, Extended64.com.
Please do not email or PM me with support questions. Please direct them to the forums instead.
Reply With Quote  
Join Date: Jul 2003
Posts: 22
Reputation: I_Byte is an unknown quantity at this point 
Rep Power: 6
Solved Threads: 0
I_Byte I_Byte is offline Offline
Newbie Poster

VBA

  #3  
Aug 7th, 2003
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
Reply With Quote  
Reply

Only community members can participate in forum threads. You must register or log in to contribute.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

 

DaniWeb Windows NT / 2000 / XP / 2003 Marketplace
Thread Tools Display Modes

Similar Threads
Other Threads in the Windows NT / 2000 / XP / 2003 Forum

All times are GMT -4. The time now is 9:41 pm.
Forum system based on vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC