Rename an save file with VBA 1

[danvzla]

Hi

Do anybody knows a way of taking an excel file, change the name and save on an specific folder with VBA. Would be great if I can drag and drop the file to a window in the form and then do all the rename and save process.

Thanks

Daniel

 

[dyarwood]

Why not use the

ActiveWorkBook.SaveAs "location and name of file"

this will save the file in the folder you want.

 

[danvlas]

Name "C:\OldPath\File.xls" As "C:\NewPath\File.xls"

Good luck



Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html