I’m sure this have been asked a thousand times, but I just need
starting hand. I have built a quote sheet and now I want to have th
quote number automatically update with the next available number. I a
thinking I can put a TXT file in the same dir and then call it fro
excel but I don’t know where to write. I want to call it Onopen.

I am thinking it should look like this. ( I’m a novice with code.)

Breneck Quote Sheet 2.Main.Range (“C17”).Value = NextSeqNumbe
(“Quote.txt”)

Am I on the right track

--
Xeno
-----------------------------------------------------------------------
Xenos's Profile: http://www.excelforum.com/member.php...fo&userid=2652
View this thread: http://www.excelforum.com/showthread.php?threadid=47197