Results 1 to 2 of 2

Thread: Output Report

  1. #1
    Join Date
    Apr 2002
    Posts
    168

    Unanswered: Output Report

    I use the following code to output my report to an excel sheet :

    DoCmd.OutputTo acReport, "MyReport", "MicrosoftExcel(*.xls)", "D:\MyWS.xls", True, ""


    It works for table, but when I try it on report, the MyWS.xls suddenly disappears everytime I run the code. Does anyone know why ? Thanks.

  2. #2
    Join Date
    Feb 2002
    Posts
    403
    DoCmd.OutputTo acReport, "MyReport", acFormat.XLS, "D:\MyWS.xls", True, ""

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •