I’m sure this have been asked a thousand times, but I just need a starting hand. I have built a quote sheet and now I want to have the quote number automatically update with the next available number. I am thinking I can put a TXT file in the same dir and then call it from 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 = NextSeqNumber (“Quote.txt”)

Am I on the right track?