excel file paths
Is there ant way to name a file/workbook path in a non-active workbook?
|
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 |
All times are GMT +1. The time now is 01:16 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com