Hi,
I want to add some code to my macro which will save the file as the File name & date from cell B10.
Any ideas on how to do this?
Hi,
I want to add some code to my macro which will save the file as the File name & date from cell B10.
Any ideas on how to do this?
Try
Please click the * below if this helps![]()
ThisWorkbook.SaveAs Filename:=Range("B10").Value & ".xlsx", FileFormat:=xlNormal
![]()
Many Thanks for your help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks