*** PLEASE NOTE: Running this file will create a new TXT file on your C-Drive ***
I have a 2 sheets in my workbook, sheet 2 is hidden (please see attached).
Currently I have cell F2 being saved to:
"Create 'C:\" & ThisWorkbook.Name & _
" Counter.txt' File")
How can I have this saved with in the same workbook under Sheet 2 "ReqNum"? Question I as is I want to customize a form for different users and each form will be Unique. Workbook will be saved on various pen-drives and used on various computers. That is why I would like to save within the same workbook.
Catch: If the person decides not to save the workbook or do a save as I still would like the number in cell F2 saved somehow on both sheets.
Any help would be greatly appreciated.
Thank you,
Holland
Reply With Quote