MACRO Save in specific folder

Gday,

can somebody help me in making macro that opens one excel file and save it to C:\tets.

I have a excel file (a.xslm) open and when i run macro i want that it opens b.xlsy (is in the same folder as a.xlsm) and save it in directory C:\test with name of today date...12182012.xlsx

Solved

code:

Please Login or Register  to view this content.