Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2008

    Open Excel from within Access?

    Hi. I'm trying to export data from an Access database into an Excel spreadsheet. I've got the 'OUTPUT TO' command sorted ok within a macro, but I'd like to now use a button to run a macro that lets you view the outputted Excel file. Does anyone know how to do this please?

    Many thanks. Kelvin

  2. #2
    jya is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Sep 2007
    If I understand correctly, you are able to create your Excel file and want to use a macro to open it.

    Have you tried using the RunApp action in your macro? You will need to know where your version of Excel is located and put it in your command line along with the file that you want to open.


    "C:\Program Files\Microsoft Office\EXCEL.exe" yourfile.xls

  3. #3
    Join Date
    Apr 2008
    Hi jya
    Many thanks! Works perfectly!

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Importing Excel into Access with few requirements
    By pickolizac in forum Import/Export Data
    Replies: 1
    Last Post: 02-18-2009, 12:02 AM
  2. excel to access
    By college_fellow in forum Access
    Replies: 0
    Last Post: 12-18-2006, 08:29 PM
  3. Excel to Access
    By college_fellow in forum Programming
    Replies: 0
    Last Post: 12-18-2006, 08:01 PM
  4. Excel Function PercentRank in MS Access ?
    By world33 in forum Programming
    Replies: 1
    Last Post: 10-27-2006, 07:01 AM
  5. Excel to Access
    By iturnrocks in forum Access
    Replies: 0
    Last Post: 08-02-2006, 10:10 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Other Forums: Microsoft Office Forums