Results 1 to 2 of 2
  1. #1
    jerryrs is offline Novice
    Windows XP Access 2003
    Join Date
    Dec 2010
    Posts
    3

    Exclamation URGENT HELP: output to excel

    I am new to MS Access and trying to modify old project.
    I changed one of the report and tried to output to Excel/Print/PreView, using the following command.
    Print and Preview works fine, showing new updated report, but excel keep bringing old not-edited report.
    I looked all over the place, but could not find. What can prevent me from running updated version.
    Please Help!!!!



    This is command I am using for output to Excel:
    DoCmd.OutputTo acOutputReport, ReportName, acFormatXLS, ReportName & ".xls", True
    I

  2. #2
    ssanfu is offline Master of Nothing
    Windows 2K Access 2000
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    What is the rest of the code? Someplace there is a line something like:

    ReportName = "TheOldReport"

    You need to change it to the new report name.

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

Similar Threads

  1. Require Urgent Help Regarding UNION and SUM
    By maddysanoo in forum Queries
    Replies: 1
    Last Post: 06-10-2010, 09:08 AM
  2. Query to run from a FORM VERY URGENT
    By prag in forum Forms
    Replies: 14
    Last Post: 10-08-2009, 01:51 PM
  3. Database size - pls help urgent!!
    By TTDD in forum Access
    Replies: 4
    Last Post: 07-21-2009, 02:39 PM
  4. Concatenation Urgent Help
    By Shoaib in forum Queries
    Replies: 0
    Last Post: 04-23-2009, 11:02 PM
  5. I need help! Urgent! :(
    By Suzan in forum Database Design
    Replies: 0
    Last Post: 04-08-2006, 11:58 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