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
![Captura%20de%20pantalla%202016-04-29%20a%20las%2023.11.01.png](/board/proxy.php?image=http%3A%2F%2Ffile%3A%2F%2F%2FUsers%2Fandresbarrezueta%2FDesktop%2FCaptura%2520de%2520pantalla%25202016-04-29%2520a%2520las%252023.11.01.png&hash=ed116039d1a17ab0c37f3d9cb32137dd)