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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

GetNextTemplateNumber

Status
Not open for further replies.
emmanuelbeaudet

emmanuelbeaudet

Programmer
Apr 16, 2002
51
CA
I had to work on a old programm someone wrote in vba on excel.
In that code I have this function : GetNextTemplateNumber that excel didn't reconize.
Someone know something about that function.
The excel file works fine on one pc, but didn't on other where I put the excel file.
I think that function read a text file with only a number in it, and get the next number, but I'm not sure.
And why it didn't work on other pc ?
I tried differente version of excel, but that didn't change anything.
The file is in excel 2K, but didn't work on another pc with excel 2K.

Thank you.
 
Sort by date Sort by votes
Check the references:
when in VBE menu Tools -> References ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886
 
Upvote 0 Downvote
And no AddIn in the working PC (same number of projects) ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886
 
Upvote 0 Downvote
no. just a few line of code to generate a number who is keep in a text file.
 
Upvote 0 Downvote
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top