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

    Arrow Unanswered: DoCmd.OutputTo Problem (Any Help is Higly Appreciated)

    I am facing one problem in MSAccess as follow where I am using following code

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

    but this staement creates Excel file which is corrupted I am sending you that corrupted file sending you report which is been used here (Screen.ActiveReport.Name)

    Pls help me out on how i can avoid this I am in a real need to solve this problem aspa any help is higly appreciated

  2. #2
    Join Date
    Oct 2003
    Location
    US
    Posts
    343

    Re: DoCmd.OutputTo Problem (Any Help is Higly Appreciated)

    What do you mean by "corrupted file"?
    Can you open and it shows garbage data or you simply cannot open it?
    You can check your ms excel software too.


    Originally posted by prasadattcs
    I am facing one problem in MSAccess as follow where I am using following code

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

    but this staement creates Excel file which is corrupted I am sending you that corrupted file sending you report which is been used here (Screen.ActiveReport.Name)

    Pls help me out on how i can avoid this I am in a real need to solve this problem aspa any help is higly appreciated

Posting Permissions

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