You can get some useful information on reading and writing files he

http://www.cpearson.com/excel/imptext.htm import/export text files

http://www.applecore99.com/gen/gen029.asp

More information on reading and writing text files from VBA

http:/www.cpearson.com/excel/events.htm
information on Chip Pearson's site on events. The Workbook_Open event can
be used to execute code when opening a workbook.

--
Regards,
Tom Ogilvy


"C_Ascheman" wrote in message
...
1)What I am wanting to do is export 1 cell ("I4") to a text file when the
focus is moved from that cell.
2)When the form is opened I want to be able to import the number from the
text file, and increase it by 1.

My employer wants to have the number that is in the "I4" cell to be auto
increased every time he opens that form. I have some programming
experience
just not alot with importing or exporting anything to anything. Any help
or
suggestions will be greatly appreciated.