phill952000
12-18-2008, 02:49 AM
hi,
i am wondering if it is possible to read the name of the most recently saved word file in a certain folder and increment it and apply the info to a text field in a newly opened word document.
i will elaborate.
what i have is a macro that, when the macro button is clicked, takes the information from form fields in a word document and stores each form field data into a different variable. within the same process the variables are used as the document save name.
now.
the first form field i have in my word document is a number that needs to increment by 1 each time i save a new document. therefore i have to check the previous number of the previous saved document so that i can enter the correct number into the new document.
i am wondering if there is any way that i could add some code to my existing macro that, when a new document is opened, can read the first form field of the previous saved document and apply the incremented number into the first form field of the new document.
i hope this makes sense.
if not please ask and i will clarify any issues.
regards
phill952000
i am wondering if it is possible to read the name of the most recently saved word file in a certain folder and increment it and apply the info to a text field in a newly opened word document.
i will elaborate.
what i have is a macro that, when the macro button is clicked, takes the information from form fields in a word document and stores each form field data into a different variable. within the same process the variables are used as the document save name.
now.
the first form field i have in my word document is a number that needs to increment by 1 each time i save a new document. therefore i have to check the previous number of the previous saved document so that i can enter the correct number into the new document.
i am wondering if there is any way that i could add some code to my existing macro that, when a new document is opened, can read the first form field of the previous saved document and apply the incremented number into the first form field of the new document.
i hope this makes sense.
if not please ask and i will clarify any issues.
regards
phill952000