While the code here is VBA, it should be directly transcribable to other languages and platforms.
The core process is really just a reiteration of previously submitted answers but I thought it was important to demonstrate how to deal with ActiveWindow when you are not within Excel's own VBA. SaveAs FileName:=fn, FileFormat:=xlOpenXMLWorkbook If CBool(Len(Dir(fn, vbNormal))) Then Kill fn 'This is where the Freeze Pane is dealt withįn = CurrentProject.Path & '\Reports\Report_' & Format(Date, 'yyyymmdd') & '.xlsx' Set xlApp = CreateObject('Excel.Application') Option Explicitĭim xlApp As Excel.Application, ws As Worksheet, wb As Workbook Using the Excel.Application object in another Office application's VBA project will require you to add Microsoft Excel 15.0 Object library (or equivalent for your own version). The 100+ Excel Shortcuts You Need to Know (Windows and Mac) The most important time-saving shortcuts for Excel 2016 for both Windows and Mac Turbo-charge your time in Excel Used at top investment banks, Wall Street Preps Excel Crash Course will turn you into an advanced Power User and set you apart from your peers. S own VBA, the ActiveWindow property must be addressed as a child of the Excel.Application object.Įxample for creating an Excel workbook from Access: To expand this question into the realm of use outside of Excel
