Help - saving files

  • Thread starter Thread starter MSL
  • Start date Start date
M

MSL

Hi

I'm trying to create a macro that automatically saves a file with a file
name taken from a cell - ie: Order number 12345

I'm sure it should be possible but I do I do it ?

Sorry if that's really basic but I'd appreciate any advice.

Thanks

Scott
 
Try

ActiveWorkbook.SaveAs Sheets("mysheet").Range("d1").Value & ".xls"
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Macro help 1
"Save As" to XML file macro using a cell's value 0
Windows 11 Windows 11 update 5
check certain cells for data before saving file 5
Average If... 12
Average Unique 7
Help with a Macro 2
Change the name of an auto save 1

Back
Top