KP_SoCal
asked on
Application.SaveAs Marco
For File1.xlsm, I would like to save file as (Application SaveAs) File2.xlsm in the same sub folder that File1.xlsm exists in. If this possible to accomplish through a macro? I assume it is. There must be a way to save the current directory path as a variable and then modify the file name by means of a len function. I’m just not sure how to piece it together. Any help would be greatly appreciated. Thanks!
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Great solutions! Thanks guys!!
ASKER