Excel file save macro.

  • Thread starter Thread starter darrenlshipley
  • Start date Start date
D

darrenlshipley

I need help with a macro. I want to be able to save a file as a listed
name, that is referenced in a cell, in a directory that is listed in a
different cell.
 
Try this:

ActiveWorkbook.SaveAs Filename:=Range("A1")

A1 would be the cell with the desired file name.
If desired, A1 can contain a specific directory to save the file. (ex -
C:\Windows\filename.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

Excel 2007: Saving a file with a Macro 1
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Macro help 2
Excel 2003 save as .XLSX 10
Help to create a macro 2
How to fix Compatibility error 3
Clear a cell's contents when document is saved 2
Pasting cell contents into a macro 1

Back
Top