Is there ant way to name a file/workbook path in a non-active workbook?
Is there ant way to name a file/workbook path in a non-active workbook?
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks