okay. i already had the how i wanted it everything works as follows.

i wrote the macros for the work order number to generate once the service order is opened and and then it has a few buttons one button is save and the other is create PDF.
when you press the save button the auto generate macro deletes itself and the button and it user cell data and the work order number to make the file name in which its saved that way once i do that and email it the button will not be there and the number will not change.. secondly i have a button that will automatically create a PDF the the same file name. once the button is pressed it deletes itself befor generating the PDF that way you don't see the button on the PDF. all works good oh and its set to save as 97-2003 file type.

heres the issue i was now asked to make to so that it has a work order number range. so right now is references a note made file on my root drive called settings and it can be any number if i open the file and type 400 and save it then open my service order template it will generate 401 and that number will be saved into the settings folder that way the next time it will be 402.

i want to make it so the user can put a starting and finishing number into the settings folder and write the macro so that when it gets to say the (current number = >(max number - 20) then let the user know its time for updated ticket numbers..


Workbook macro
Please Login or Register  to view this content.

Work sheet code


Please Login or Register  to view this content.