Good morning all.

I have created a form for users to fill in on a worksheet in a fil
named "IPR Test". It is designed so that the initial user will fil
out the first portion of cells, click a button at the bottom that wil
open another file (Log) and copy the data, save and close the log file
save the file, and send it via email. In cell V5, it has a formula t
add the next number (autonumber), and the file saves with this code:

FName = "\\Nfil108\qa\Shared Files\Testing\" & "IPR "
Range("A1").Value & ".xls"
ThisWorkbook.SaveCopyAs FileName:=FName

Everything works as it should with one little glitch. I need to b
able to turn the autonumbering formula off once the file has been save
with the new name. As it is now, when the e-mail recipients open th
file from their e-mail, it bumps up to the next number, when I want i
to stay the same. In other words, the only time I want the number t
increase is when the original file "IPR Test" is opened.

Any help would be greatly appreciated

:)

Thanks in advanc

--
Message posted from http://www.ExcelForum.com