Saving in a location

[Greg Brow]

I was wondering how to save a file into the directory client file. I have
already got the name suggest but it is just saving straight into my
documents.

Thanks in advance

Greg

 

[Chip Pearson]

You need to include the entire path in the SaveAs statement.
E.g,.

ActiveWorkbook.SaveAs filename:="H:\Temp\Test\Book1.xls"

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Greg Brow]

thank you

Greg

You need to include the entire path in the SaveAs statement. E.g,.

ActiveWorkbook.SaveAs filename:="H:\Temp\Test\Book1.xls"

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com