![]() You can Save the Workbook to Specific Folder by showing the Save Dialog Box to user. Save Workbook to Specific Folder using Save Dialog Box 'wkb.SaveAs Filename:="C:\WorkbookName1.xls" If you are dealing with more than one workbook, you will need this method to access a specific Excel Workbook. Set to an Object and Save it, so that it is easy to refer to your workbook to do further tasks. 'ActiveWorkbook.SaveAs Filename:="C:\WorkbookName1.xls" ![]() The following example show you how to save an Excel Workbook in Specific folder using SaveAs method:ĪctiveWorkbook.SaveAs "C:\WorkbookName.xls"
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |