+ Reply to Thread
Results 1 to 5 of 5

VBA Tables Help.

  1. #1
    Registered User
    Join Date
    05-14-2014
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    50

    VBA Tables Help.

    Hi Guys,

    Hope you can help.

    I need to copy data from one, workbook, to a table in another workbook.

    For example, i coded this to copy data from one workbook to another, and to check if the value exists. but I can't for the life of me figure out how to change it to work with excel tables.

    Please Login or Register  to view this content.
    Any help would be really appreciated


    Thanks

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: VBA Tables Help.

    Cross-posted at http://www.mrexcel.com/forum/excel-q...ns-tables.html

    Why not respond to the person that gave you a suggestion there?
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    05-14-2014
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    50

    Re: VBA Tables Help.

    Sorry didn't realise anyone had responded, also as this is a different forum I thought I post here to increase my chance of any help
    Last edited by RandomPezzer; 10-04-2016 at 07:24 PM.

  4. #4
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,447

    Re: VBA Tables Help.

    also as this is a different forum I thought I post here to increase my chance of any help
    Not the way it works. Many of the same people look at many of the forums. So, all that happens is you waste everyone's time, particularly if you don't provide links to your cross posts.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  5. #5
    Registered User
    Join Date
    05-14-2014
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    50

    Re: VBA Tables Help.

    No worries, Sorry.

    I have managed to figure out how to adjust my code now, so no help needed now.

    Thanks

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. macro to Create 3 tables from tables in the attached sheet
    By irfanparbatani in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-12-2015, 08:13 AM
  2. Excel Automation: Updating Pivot Tables, Charts, and Tables
    By Lemguin in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-03-2015, 04:25 AM
  3. [SOLVED] access connection to 2 tables to find a common name in both tables
    By Megatronixs in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-19-2014, 08:48 AM
  4. Multiple Data Tables Link and Calculate onto Target Tables
    By billexchry in forum Excel General
    Replies: 6
    Last Post: 03-04-2011, 02:42 PM
  5. Creating data tables from a database without using pivot tables
    By gareth.campbell in forum Excel General
    Replies: 4
    Last Post: 11-24-2010, 12:23 PM
  6. Code List Tables - missing the Linked Tables
    By RxMiller in forum Access Programming / VBA / Macros
    Replies: 1
    Last Post: 12-10-2009, 01:13 PM
  7. Replies: 3
    Last Post: 07-25-2006, 05:00 AM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1