PDA

View Full Version : file rename in vba



ltworf13
10-22-2007, 01:08 PM
I have a file that gets created. Onces it's created I need the file name to changed in vba.
Any suggestions would be appreciated.
Thx

Bob Phillips
10-22-2007, 01:17 PM
Do you want to rename an activeworkbook, if so then use Workbooks.SaveAs.

If you want to rename a file on the HDD, look at Name in help.

ltworf13
10-22-2007, 01:43 PM
file in HDD thx , I looked up Name and that's what I needed