Results 1 to 5 of 5
  1. #1
    Join Date
    Aug 2008
    Posts
    4

    Unanswered: Merging cells in excel from access

    Code:
    exSheet.Range("A1", "Q1").Merge ()
    I do not know how to format this so that it works as this doesnt. I can't find any information through google and the help file doesn't sufficiently describe how to use. Any help would be appreciated..
    Last edited by BigPaully; 08-28-08 at 13:28.

  2. #2
    Join Date
    Sep 2006
    Location
    Surrey, UK
    Posts
    995
    Provided Answers: 2
    Daft question, but have you set up a link to the Excel library?

  3. #3
    Join Date
    Aug 2008
    Posts
    4
    Yeah I have the link

  4. #4
    Join Date
    Sep 2006
    Location
    Surrey, UK
    Posts
    995
    Provided Answers: 2
    Try recording a macro in Excel to merge cells, then copy the code to Access.

  5. #5
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    ▲ Agreed, that's where I would start.

    I can only suggest one correction here... "A1:Q1" would seem to be needed ... not ("A1" , "Q1"). As for the rest, not sure as I do almost zero communications with Excel from Access.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

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