Results 1 to 5 of 5
  1. #1
    Join Date
    Apr 2008
    Posts
    189

    Question Unanswered: How to export a Form into Excel and add special headers and text

    Hello,
    I would like some help to export an Access Form to an Excel file, but I would like to add some text on the first rows (of the Excel).

    Check this example I just made up:

    http://img87.imageshack.us/img87/5427/dibujozg0.jpg

    Any ideas how I can do that?

    Thank you in advance for your help.
    Last edited by pepemosca; 04-27-08 at 19:41.

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    The code bank at the top of the Access forum will most likely have the answer to this!

    Look for the Excel automation stuff by pootle flump
    George
    Home | Blog

  3. #3
    Join Date
    Apr 2008
    Posts
    189

    Wink

    Thanks!

    I'll check that out!
    Thanks again for the help.

  4. #4
    Join Date
    Apr 2004
    Location
    outside the rim
    Posts
    1,011
    A quick way to get at least the formats and a user defined header cell:

    Export a Form rather than a Report.

    Setup the form with the fields you want. Name the text boxes what you want the column headers to be and set the text box format to how you want Excel to format it.

    Quick and easy!
    have fun!

    Todd S.
    click to email


    Independent Development Consultant
    Biz db & reports - SQL, Access, Crystal, Seradex and more
    Small, custom, unique programs - Office, VBA, .NET


    _________________________________________________
    Favorite message from Windows:
    There was an error displaying the previous error message

    Sadly, there was no error number to look up ...

  5. #5
    Join Date
    Apr 2008
    Posts
    189
    Quote Originally Posted by tcace
    A quick way to get at least the formats and a user defined header cell:

    Export a Form rather than a Report.

    Setup the form with the fields you want. Name the text boxes what you want the column headers to be and set the text box format to how you want Excel to format it.

    Quick and easy!
    Thank you for your reply.

    Yes, you are right.
    But I was looking for more formating, like adding a header.

    But with the Excel automation stuff by pootle flump I got a solution.

Posting Permissions

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