Results 1 to 5 of 5

Thread: Excel .xlsm format export from Access 2007

  1. #1
    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.

  2. #2
    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.

  3. #3
    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.

  4. #4
    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.

  5. #5
    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.

Similar Threads

  1. Ms Project 2007 Export And Data Field Format
    By edwormald in forum Windows Software
    Replies: 1
    Last Post: 01-05-2010, 05:36 PM
  2. Access 2007 not bale to export report to excel
    By Zavier in forum Windows Software
    Replies: 4
    Last Post: 07-07-2009, 06:36 PM
  3. Export Excel 2003 sheet in csv Format
    By BADRU in forum Windows Software
    Replies: 3
    Last Post: 06-04-2009, 10:23 PM
  4. Export MS Project 2007 to Excel
    By Manik in forum Microsoft Project
    Replies: 4
    Last Post: 13-02-2009, 10:34 PM
  5. Want to Export Access to Excel 2003
    By Darsheet in forum Windows Software
    Replies: 4
    Last Post: 08-01-2009, 03:40 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,711,627,145.22486 seconds with 17 queries