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!

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

Vbscript code to auto increment by 1 text value '0000001'

Status
Not open for further replies.
kdjonesmtb2

kdjonesmtb2

Technical User
Joined
Nov 19, 2012
Messages
93
Location
US
What is the correct vbscript to auto increment a starting txt value of '0000001 by 1

For example

0000001
0000002
0000003

etc

Thanks
 
Sort by date Sort by votes
Here's one way:

Code: 
[blue]Public Function AutoInc(strSource)
    AutoInc = Right(String(6, "0") & strSource + 1, 7)
End Function[/blue]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

K
  • Locked
  • Question Question
VBSCRIPT dont work windows 11 23h2 ???
Replies
2
Views
1K
SoftwareRT
SoftwareRT
Alexvb6
  • Locked
  • Question Question
Deprecation of VBScript + Classic ASP: How to Ask Microsoft to cancel their planned craziness
Replies
0
Views
893
Alexvb6
Alexvb6
bdwilcox
  • Locked
  • Question Question
Trying to adapt VBScript to search if machine is in an AD group
Replies
8
Views
2K
SoftwareRT
SoftwareRT
bdwilcox
  • Locked
  • Question Question
Script seeing input variable value as blank but sees hard-coded value
Replies
6
Views
1K
bdwilcox
bdwilcox
Peterdo
  • Locked
  • Question Question
Read code
Replies
1
Views
559
strongm
strongm

Part and Inventory Search

Sponsor

Back
Top