Results 1 to 6 of 6
  1. #1
    Join Date
    Oct 2003
    Location
    Thailand
    Posts
    19

    Unanswered: ... How to transfer the report in access to the Excel file, Help me please

    I want to transfer the report in access to the excel file ....

    How to programming in vba ?!?!
    Or tell website about it to me please.

    Thank you very much
    ( I want to set borders in cell, underborder only in cell ,underline of text, create circle, sum ....etc in excel.)

  2. #2
    Join Date
    Oct 2003
    Location
    Thailand
    Posts
    19
    Ohh I forget something...

    I use AccessXP sp2 Thai + Winxp Pro sp1a

  3. #3
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1
    Try this code

    DoCmd.OutputTo Objekttyp[, Objektname][, acFormatXLS][, FileName]


  4. #4
    Join Date
    Oct 2003
    Location
    Thailand
    Posts
    19
    Ok I used this code ....

    But I want to set borders in cell, underborder in cell, underline of text, sum data in each cells, ...etc ....

    This code could transfer data from report to excel file too, But it cannot set borders in cell, underline of text, sum data in each cells, ...etc .

    Help me again please...

    Thank you very much.

  5. #5
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1
    Sorry I have less experience in EXCEL programming

  6. #6
    Join Date
    Oct 2003
    Location
    Thailand
    Posts
    19
    Nevermind

    Thank you very much to lost your time for solved this problem...

Posting Permissions

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