Excel .xlsm format export from Access 2007
I have a number of procedures which export from access to macro enabled excel spreadsheets. But I am no longer capable to do this in Access 2007. So here I require some help of yours. If possible then please provide some help about my topic. I find it in many places but then also I can’t find the solution for this. So please if anyone have any solution for this or any related solution is there then also please provide.
Re: Excel .xlsm format export from Access 2007
I have some solution for this; actually not solution but a few information regarding your difficulty. You can duplicate data as of a Microsoft Office Access 2007 database addicted to a spreadsheet by exporting a database object to a Microsoft Office Excel 2007 workbook. You do this by means of the Export Wizard in Office Access 2007.
Re: Excel .xlsm format export from Access 2007
I as well have the similar problem. In Access 2003, I exported data into an Excel 2003 file which contained VB code which rearrange the auto filter upon exit or save. Excel 2003 sights this as a macro as does Excel 2007. The export code is as below in Access 2003:
Code:
Public Function ExportSuppliersAllExcel()
Dim oXLApp As Object
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "QrySuppliersALL", "V:\Procurement\Reports\All Suppliers.xls", True
Set oXLApp = CreateObject("Excel.Application")
oXLApp.workbooks.Open "D:\Procurement\Reports\All Suppliers.xls"
oXLApp.Visible = True
Unluckily, it does not come into view that Access 2007 will permit you to export to an Excel 2007 .xlsm macro enabled file format.
Re: Excel .xlsm format export from Access 2007
I attempt to export an Access query to an Excel file like I have completed hundreds of times with earlier versions. Just place, I wish to export a query from Access 2007 to Excel 2007 to an .xlsm file. While I have an inquiry open and click External Data-export to Excel the xlsm file arrangement is not even in the record.
Re: Excel .xlsm format export from Access 2007
Are you annoying to export to a fresh Excel file or an existing Excel file? If you are annoying to an export to a fresh Excel file, I would think you would require the xlsx format. Xlsm is a Macro Enabled Excel file. If it is a fresh file, it would not have any macros in it, so I am not certain why you would require exporting to that alternative.