excel file paths
The only way to name a file (or change its path) is to save it (to a different
location)?
And if you're writing code to do this, the workbook doesn't need to be active.
dim wkbk1 as workbook
dim wkbk2 as workbook
set wkbk1 = workbooks("book1.xls")
set wkbk2 = workbooks("book2.xls")
wkbk1.activate
'now wkbk1 is active
wkbk2.saveas filename:="c:\temp\book99.xls", fileformat:=xlworkbooknormal
Jane wrote:
Is there ant way to name a file/workbook path in a non-active workbook?
--
Dave Peterson
|