Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004

    Talking Unanswered: Export Error from Access 2002 to Excel - Help Higly Appreciated

    I am using following statement in my access 2002 code which creates excel file which is get corrupted on creation which I can not use further

    code is follow...

    DoCmd.OutputTo acOutputReport, Screen.ActiveReport.Name, acFormatXLS, txtExcelName, False

    Anybody has got any idea for how to solve this I am attaching Excel error in jpg formt to llok at it

    Please help me out its urgent and any help will be higly appreciated
    Attached Thumbnails Attached Thumbnails excel_export_error.jpg  

  2. #2
    Join Date
    Feb 2004
    Try to explicitly call out the Report name. I think when you call out the activeReport via screen method, the screen active becomes the form you are trying to create-- this could be a referential break on the new event of Output to...


Posting Permissions

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