zljordan
12-11-2015, 11:02 AM
Hello All,
I am having a hard time figuring out how to create a macro that will allow me to save a current worksheet as a .xlsx file in a filepath that has been selected on the sheet.
I currently have a combo box where I select the client's name on a WS named "Save". Once a name is selected, their corresponding file path is looked up from a WS named "FilePaths". This also looks up their name from the "FilePaths" WS which creates the desired name of the file I would like to Save As, using the formula =INDEX(ClientName,$B$4,1)&" "&"Form"&" "&TEXT(TODAY(),"mm-dd-yy").
I have attached a copy of the workbook I am using to give you a better understanding of what I am working with. Basically I would like to be able to select a name and save the current worksheet as a new workbook is in the "SaveToPath" named range, and have the new WB saved as the name in "FileNameSave" named range.
Thank you very much for your help.
I am having a hard time figuring out how to create a macro that will allow me to save a current worksheet as a .xlsx file in a filepath that has been selected on the sheet.
I currently have a combo box where I select the client's name on a WS named "Save". Once a name is selected, their corresponding file path is looked up from a WS named "FilePaths". This also looks up their name from the "FilePaths" WS which creates the desired name of the file I would like to Save As, using the formula =INDEX(ClientName,$B$4,1)&" "&"Form"&" "&TEXT(TODAY(),"mm-dd-yy").
I have attached a copy of the workbook I am using to give you a better understanding of what I am working with. Basically I would like to be able to select a name and save the current worksheet as a new workbook is in the "SaveToPath" named range, and have the new WB saved as the name in "FileNameSave" named range.
Thank you very much for your help.