Results 1 to 9 of 9
  1. #1
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Insert a row in excel from access (Access 2003 SP2)

    I would like to know what the command is to insert a row before a specified row.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Insert a row in excel from access (Access 2003 SP2)

    That is an Excel question, not an Access question, even if you want to do it from Access, so I'm moving this thread.

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Insert a row in excel from access (Access 2003 SP2)

    Use

    obj.Rows(37).Insert

    or

    obj.Range("A37").EntireRow.Insert

    where obj is an Excel Worksheet object.

  4. #4
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Insert a row in excel from access (Access 2003 SP2)

    It is an access question, i am populating an excel sheet from Access.

    Im sorry if i didn't make that clear in the first post.

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Insert a row in excel from access (Access 2003 SP2)

    But I assume that you're using Automation to control Excel from Access. So it's still an Excel question.

  6. #6
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Insert a row in excel from access (Access 2003 SP2)

    Ok thanks.

  7. #7
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Insert a row in excel from access (Access 2003 SP2)

    After inserting a row do you need to refresh the shhet or something?

    I have gaps.

  8. #8
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Insert a row in excel from access (Access 2003 SP2)

    That worked beautifully of course, thank you.

  9. #9
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Insert a row in excel from access (Access 2003 SP2)

    No, the change is instantaneous.

Posting Permissions

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