Go Back   TechArena Community > Software > Windows Software
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



Excel .xlsm format export from Access 2007

Windows Software


Reply
 
Thread Tools Search this Thread
  #1  
Old 26-11-2010
Member
 
Join Date: Nov 2010
Posts: 40
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.

Reply With Quote
  #2  
Old 26-11-2010
Member
 
Join Date: May 2008
Posts: 860
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.
Reply With Quote
  #3  
Old 26-11-2010
Member
 
Join Date: May 2008
Posts: 913
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.
Reply With Quote
  #4  
Old 26-11-2010
Member
 
Join Date: May 2008
Posts: 979
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.
Reply With Quote
  #5  
Old 26-11-2010
Member
 
Join Date: Nov 2008
Posts: 996
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.
Reply With Quote
Reply

  TechArena Community > Software > Windows Software
Tags: , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Excel .xlsm format export from Access 2007"
Thread Thread Starter Forum Replies Last Post
Ms Project 2007 Export And Data Field Format edwormald Windows Software 1 01-05-2010 05:36 PM
Access 2007 not bale to export report to excel Zavier Windows Software 4 07-07-2009 06:36 PM
Export Excel 2003 sheet in csv Format BADRU Windows Software 3 06-04-2009 10:23 PM
Export MS Project 2007 to Excel Manik Microsoft Project 4 13-02-2009 10:34 PM
Want to Export Access to Excel 2003 Darsheet Windows Software 4 08-01-2009 03:40 PM


All times are GMT +5.5. The time now is 07:09 AM.