Hello
I hope you can help me as I am really new with macros in Excel
I have a Purchase Order form that I need to get a new number every time I open the template and, when finished (closing/saving and/or priniting), the default saving name be a construction of fields and texts from within the form.
In specific, I need the file to be named as: PO12345 - YYYYMMDD - VENDOR, where PO is text, 12345 is the automatically generated number from field G5, the text " - ", YYYYMMDD being the year-month-date in field G12 and finally the vendor name from field C11
I hope you can help me with the needed VBA code.
Thanks
I hope you can help me as I am really new with macros in Excel
I have a Purchase Order form that I need to get a new number every time I open the template and, when finished (closing/saving and/or priniting), the default saving name be a construction of fields and texts from within the form.
In specific, I need the file to be named as: PO12345 - YYYYMMDD - VENDOR, where PO is text, 12345 is the automatically generated number from field G5, the text " - ", YYYYMMDD being the year-month-date in field G12 and finally the vendor name from field C11
I hope you can help me with the needed VBA code.
Thanks
