macro save as to a destination folder

[poitachi]

hi! anybody can me to solve this problem: i have a file name A.xls, after finish the job, i want to save A.xls as a date taken from one of the cell in A.xls. let's say cell C3 has "13 september 2010". so, the new file '13 september 2010.xls' will be saved into a folder named 'monthly' which is in My Document drive D.

[Leith Ross]

Hello poitachi,

This code will work provided "D" is your default hard drive. This would need to be added into the appropriate macro in your code.

Please Login or Register  to view this content.