Results 1 to 2 of 2
  1. #1
    taimysho0 is offline Competent Performer
    Windows XP Access 2000
    Join Date
    Nov 2011
    Posts
    286

    Macros to reference another workbook in Excel?

    i know this is an access forum but wasnt able to get any responses in excel forums so was wondering if i can have some help




    i have 2 files (key.xlsx and test.xls)

    i want to create a button in excel with macros where it opens up another workbook (my documents/key.xlsx) and look at the text in rows A2 through A29 up to column C. If there are any rows that are different from the current file thats open (test.xls), starting from A8 and down, then insert these different rows from key.xlsx into test.xls and put "0" as values for columns 'ticket count' and '% total'.


    key.ziptest.zip

  2. #2
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,442
    I don't think you'd be able to do this with a macro, you'll likely want to use VBA because you're comparing individual cells to one another. Added to that is that your data does not seem to follow a specific sort order which would make things even more difficult. How are you determining what is a 'duplicate' value? Is it strictly by the description in the category, or do all 3 columns have to match for it to be considered a duplicate?

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Import excel sheet data into Ms-access using VBA macros
    By gokul1242 in forum Import/Export Data
    Replies: 2
    Last Post: 10-02-2012, 04:39 AM
  2. Output Report to Excel using MACROS
    By taimysho0 in forum Programming
    Replies: 1
    Last Post: 02-22-2012, 03:49 PM
  3. macros: any way to record like excel?
    By stevepcne in forum Access
    Replies: 2
    Last Post: 11-18-2011, 12:42 PM
  4. Run Excel Macros in Access
    By jo15765 in forum Programming
    Replies: 8
    Last Post: 10-13-2011, 01:20 PM
  5. Using Excel macros in Access
    By Lorlai in forum Programming
    Replies: 2
    Last Post: 06-03-2011, 02:01 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums