Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 2 of 2

Thread: Access : VBA copy data to another workbook

  1. #1
    Join Date
    2nd March 2004
    Posts
    1
    hi i have a workbook 1 that hav data from a:h
    and i want to added this data to workbool 2 in sheet 1, the data can be copy in the same order, and every tiime i run the macro the data ransfered is added to the old data already transfered.thanks

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    7th February 2003
    Location
    Kewarra Beach, Cairns - TNQ
    Posts
    1,055
    luisve,

    Try this code and adapt to suit your needs:

    Sub Macro1()

    Sheets("Sheet1").Range("a1", Range("h65536").End(xlUp)).Select
    Selection.Copy
    Workbooks("Book2").Activate
    Sheets("sheet1").Range("a65536").End(xlUp).Offset(1, 0).Select
    ActiveSheet.Paste

    End Sub

    NB code assumes both workbooks are open and that the code is being run while book1 is the active book.

    Regards
    Weasel
    Kind Regards
    Pesky Weasel
    "I have a plan so cunning, you could put a tail on it and call it a Weasel." EB
    Eagles may soar, but Weasels don't get sucked into jet engines.
    Templates and Calculators
    The Way of the Weasel
    Download Ivan & Colo's HTML Maker Here
    101 Excel Hacks - Great New Book
    Huge Savings on Excel Training

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. Copy Data From To Access
    By RB123 in forum Excel and/or Access Help
    Replies: 1
    Last Post: December 22nd, 2007, 20:04
  2. Replies: 2
    Last Post: May 25th, 2007, 02:30
  3. Import Data To Access From An External Workbook
    By Heavy in forum Excel and/or Access Help
    Replies: 2
    Last Post: October 22nd, 2006, 06:40
  4. Replies: 3
    Last Post: September 21st, 2006, 12:42
  5. Access : VBA Saving a copy of an excel Workbook in a OLE fie
    By Javy Dreamer in forum Excel and/or Access Help
    Replies: 1
    Last Post: March 16th, 2004, 06:56

Bookmarks

Posting Permissions

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