Results 1 to 8 of 8
  1. #1
    Join Date
    Jun 2004
    Location
    Seattle, WA
    Posts
    601

    Unanswered: Cleaning up some excel exports

    I am running a query, and exporting it to excel. A few of the fields have dates, and one is a memo field. When I export it to excel, the dates show up as hash marks. If I resize the field in excel, the dates appear. Also some of the memo fields wrap and the cell expands to show the multiple lines,and other times it doesn't. I was wondering if there was a way for me to tell excel to resize properly so my users don't have to?
    Ryan
    My Blog

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Hi Ryan

    Some of that sort of stuff is (I think) done in the Export to Excel attachment in the codebank sticky of this forum. Try running it and see how you get on.
    Testimonial:
    pootle flump
    ur codings are working excelent.

  3. #3
    Join Date
    Jun 2004
    Location
    Seattle, WA
    Posts
    601
    There is an excel automation thing done by you. I will look at it when I get in.
    Ryan
    My Blog

  4. #4
    Join Date
    Jun 2004
    Location
    Seattle, WA
    Posts
    601
    Dan, I have looked at the example, put the code in just like it was*, and I get an error. It says that " Dim exApp As Excel.Application" is not defined. From what I can tell, all that is is a var decloration.

    *- I edited the SQL query
    Ryan
    My Blog

  5. #5
    Join Date
    Nov 2005
    Posts
    113
    You must apply the reference to the Excel. Go in the vba-code window to tools and reference and choose the "Microsoft Access 8.0 Object Library"

  6. #6
    Join Date
    Jun 2004
    Location
    Seattle, WA
    Posts
    601
    Oh ok. Thanks. Now it exports, but it looks different than Dan's. I'll look to see if I can fix that.
    Ryan
    My Blog

  7. #7
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Quote Originally Posted by Julita
    You must apply the reference to the Excel. Go in the vba-code window to tools and reference and choose the "Microsoft Access 8.0 Object Library"
    Yup. Or you can take a look at the Late Binding information and do things that-a-way (as recommended by Roy Vidar & several supporting articles).
    Testimonial:
    pootle flump
    ur codings are working excelent.

  8. #8
    Join Date
    Jun 2004
    Location
    Seattle, WA
    Posts
    601
    I got it working.
    Ryan
    My Blog

Posting Permissions

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