+ Reply to Thread
Results 1 to 2 of 2

How can I work with copied data from another workbook?

  1. #1
    Valued Forum Contributor
    Join Date
    10-05-2014
    Location
    Regina, SK Canada
    MS-Off Ver
    Excel for Mac 11
    Posts
    330

    How can I work with copied data from another workbook?

    I want to examine the copied range from another spreadsheet before the user pastes it into a selected cell on the current workbook.
    How do I refer to that copied data on the clipboard? ('Selection' does not work because it refers to the cell on the current sheet.)
    Is the a VBA object for it?
    (Hope I explained this adequately.)

    Thanks In Advance,
    - Stu
    Last edited by StuCram; 11-05-2014 at 01:16 AM.

  2. #2
    Valued Forum Contributor
    Join Date
    10-05-2014
    Location
    Regina, SK Canada
    MS-Off Ver
    Excel for Mac 11
    Posts
    330

    Re: How can I work with copied data from another workbook?

    Here's one approach that I tried and seems to work.
    a) make a new sheet
    b) paste the imported data there; it will be the current 'selection' on that sheet.
    c) examine that select ( rowCount = selection.rows.count ; test size, values etc. for validity)
    d) copy that
    e) switch back to the original sheet & paste or paste special that data at the given location there
    f) delete the temporary sheet from step a.

    Please Login or Register  to view this content.
    This method seems to work for my needs but is there an easier way?

+ 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. [SOLVED] Help with code to paste copied data into a destination workbook
    By Grizz in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-26-2014, 06:27 AM
  2. [SOLVED] When data is copied to another workbook, hyperlinks as not copied or they don't work
    By KK1234 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 01-17-2014, 06:46 AM
  3. Data will be copied from a separate workbook to worksheet RawData in another workbook
    By pghpens44 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-13-2014, 10:07 AM
  4. [SOLVED] Updating a copied workbook with data from the original
    By simonlblea in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-10-2013, 08:33 AM
  5. Importing data from worksheet to be copied in another workbook
    By klowjet in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-13-2010, 10:49 AM

Tags for this Thread

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