ExcelBanter - Save File to specific place`

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Save File to specific place` (https://www.excelbanter.com/excel-programming/399661-save-file-specific-place%60.html)

Steve[_4_]

Save File to specific place`

Hi everyone, is there a way I can save a file to a path that is
specified in Sheet1 Cell A1? Thanks!

Dave Peterson

Save File to specific place`

with activeworkbook
.saveas filename:=.worksheets("sheet1").range("a1").value & ".xls", _
fileformat:=xlworkbooknormal
end with

No validity checks at all!

Steve wrote:

Hi everyone, is there a way I can save a file to a path that is
specified in Sheet1 Cell A1? Thanks!

--

Dave Peterson

All times are GMT +1. The time now is 12:54 AM.