Save File to specific place`

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

Hi everyone, is there a way I can save a file to a path that is
specified in Sheet1 Cell A1? Thanks!
 
with activeworkbook
.saveas filename:=.worksheets("sheet1").range("a1").value & ".xls", _
fileformat:=xlworkbooknormal
end with

No validity checks at all!
 
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

using two cell references to make up the save as file name 3
How to reference a cell from anther workbook without opening it 0
Change file name when saved to C drive 2
Stopping a macro to edit the template then re-saving the macro for use 4
Excel VBA help: Text file formatting 19
Determine a computer's fingerprint? 8
Save with ref. to cell A1 2
Return list of file names from specific directory 3

Back
Top