Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

open spreadsheet from Access

Discussion in 'Information Technology' started by JOM, Jul 28, 2006.

  1. JOM

    JOM
    Expand Collapse
    Guest

    I have a macro that is exporting data from a query to a spreadsheet. the
    spreadsheat is recreated all the time I run that macro. I would like to open
    that spreadsheet as soon as the macro finshes exporting. How will I do that.
     
  2. Loading...


  3. fredg

    fredg
    Expand Collapse
    Guest

    On Thu, 15 Jun 2006 14:48:02 -0700, JOM wrote:

    > I have a macro that is exporting data from a query to a spreadsheet. the
    > spreadsheat is recreated all the time I run that macro. I would like to open
    > that spreadsheet as soon as the macro finshes exporting. How will I do that.


    Use code.
    DoCmd.OutputTo acOutputQuery, "QueryName", acFormatXLS,
    "c:\FolderName\FileName.xls", True

    Or.. if you are using TransferSpreadsheet, add:

    Application.FollowHyperlink "C:\FolderName\FileName.xls"

    after the transfer is completed.
    --
    Fred
    Please respond only to this newsgroup.
    I do not reply to personal e-mail
     

Share This Page