Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

bates macro in word 2003

Status
Not open for further replies.

marieko

Instructor
Jun 11, 2007
4
US
I've already posted this to the office forum and was told that it was a VBA question so here it is again....I need to create a bates macro that will work in word 2003; similar to one we have in wordperfect. I don't have a lot of experience with macros and don't know where to start; can someone point me in the right direction. thanks
 
As was asked in the other forum (thread68-1376786),

what is a "bates macro"?

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.
 
Curiosity got the better of me so I Googled.

I still don't know what you're asking, but there are lots of hits for [google]word bates macro[/google]. Any help there, marieko?

If not, please answer the question (what do you mean by "bates macro") and state what you have already tried.

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.
 




This is a NUMBERING STAMP.

This is REALLY Sequential Numbering of whatever, tickets, invoices, whatever.
Code:
iSeqn = inputbox("enter starting number")
iEnd = inputbox("enter ending number")
do
'now do something
 
   iseqn = iseqm + 1
loop until iseqn => iend
msgbox "I'm done!"

Skip,
[sub]
[glasses] [b][red][/red][/b]
[b][/b] [tongue][/sub]
 




sorry for the typos.

Please use terms that EVERYONE can relate to!!!

Very few people know about Bates Stamps.

Furthermore, this is like referring to facial tissue as Kleenex!

Bates is a Trade Name, not a method!!!

Skip,

[glasses] [red][/red]
[tongue]
 
marieko, please respond. I did not google as my curiosity did not get that far. From taking a peek at what anotherhiggins googled, it seems there are products that are set up for this.

If you are going to post here, please try to be very concise and clear. People may not know what you mean. All we can do is read what you WRITE.

If you thinking about making your own label sequencing macro, you may want to reconsider. NOT that I am trying to discourage you. I do not know the level of sophistication required for this task. However, it may not be the best project to start learning VBA.

If you have any time constraints, then trying, and possibly purchasing, an existing products may be the optimal route. I have no doubt that a person with VBA experience could make a similar template, but...what is it worth to you? If it takes three weeks of hard slogging for you to get it yourself, is that worth it?

If you want to give it a try, by all means do so. When you have specific questions regarding coding, ask.

I did not actually download and look at the templates that seem to be available, but if it is a sequencing issue, you may want to look at using SEQ fields. Or perhaps iterating a Document variable. Or maybe even writing out to a log file.

faq219-2884

Gerry
My paintings and sculpture
 
Sorry I was not clear enough, this is a sequentially numbered label with leading zeros; the user inputs letters before the zeros, inputs the number of leading zeros; inputs the starting and ending number; and the macro opens a dialog box that tells the user how many pages of labels to put in the printer, the user clicks ok and then it runs the correct number of labels with all the information. I googled and did see some macros available for purchase; looks like I'll have to go that route, thanks for all your responses.
 




marieko,

Before computers, every company that produced invoices, workorders, tickets, etc, needed a means to UNIQUELY IDENTIFY each document or set of documents. Hence, machines like the Bates Stamper.

Today, almost every comapny in the world does something similar for invoices, workorders, tickets etc. My company internally produces uniquely identified documents, and identify serialized products for customers, with nary a Bates in sight. It's all done with each particular system keeping track of the last used unique identifier. Some of our identifiers are not even all numeric. Its just a UNIQUE NUMBERING SYSTEM for each.

Skip,

[glasses] [red][/red]
[tongue]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top