Search results

  1. M

    Exporting Crystal to Excel using Access VBA

    Hi, have searched both VBA & crystal forums but can't find an answer to this. Here goes anyway... I've been given a set of crystal reports that I need to export to excel. I can do so individually using Crystal Reports Viewer but this is time consuming for multiple reports. I'm trying to use...
  2. M

    Exporting from Access to Excel Run Time Error 31532

    That sorted it pbaldy. I put in an if statement before the DoCmd "If Left(qdf.Name, 3) = "qry" Then..." and that worked. Thanks!
  3. M

    Using Access VBA to convert Crystal Reports to Excel

    Thanks for the response kevlray.
  4. M

    Exporting from Access to Excel Run Time Error 31532

    Hi there, I'm trying to export queries from access to excel using the DoCmd option. The code (see below) works to a point - it exports some of the queries before I get a run time error: "31532: Microsoft Access was unable to export the data". The worksheet tabs also do not pick up the query...
  5. M

    Using Access VBA to convert Crystal Reports to Excel

    Hi Guys, Am not sure whether this belongs here or in the VBA forum. Have searched both but can't find an answer. Here goes anyway... I've been given a set of crystal reports that I need to export to excel. I can do so individually using Crystal Reports Viewer but this is time consuming for...
Top Bottom