excel file paths

[Guest]

Is there ant way to name a file/workbook path in a non-active workbook?

 

[Dave Peterson]

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