+ Reply to Thread
Results 1 to 2 of 2

VBA: Copy and Past between different instances

  1. #1
    Registered User
    Join Date
    09-09-2017
    Location
    Brasilia, Brazil
    MS-Off Ver
    2016
    Posts
    1

    Question VBA: Copy and Past between different instances

    Hi, Everyone!

    I'm from Brazil and this is my first post. Sorry for start asking for help, but I already searched everywhere, without any solution for my problem. Maybe you can help me.

    The question is:

    I bought a software (with a large database), and its output is a simple Excel workbook, not saved anywhere (no path), named genericly "Book1", that simply pop up on my screen.

    Everytime I ask the software for this output, I need to copy the content of this workbook and paste into another workbook, a mother-workbook, as I named it, to consolidate all the data.

    Once I have to repeat this action dozens times a day, I thought it would be a great idea create a VBA code to automate this task. So... I made a very simple one:

    Please Login or Register  to view this content.
    The problem is... Each time the software output a new workbook, it seems that is created a new instance inside the Excel, for wich my macro doesn't reach. I mean, I run de code, but nothing happens, because my mother-workbook doesn't find the generic, unsaved and located in another excel instance "Book1".

    If I open the mother-workbook after the output is opened, OK, the code works, because both are in the same instance. But as I need to keep the mother-workbook open all the time, I can't do this. I don't want to save each new output file either. It would take me a lot of time.

    I'm using the 2016 version of Excel, but already tried the 2010 as well. My OS is Windows 10 Pro.

    Any thoughts?

    Thanks a lot!

  2. #2
    Valued Forum Contributor WasWodge's Avatar
    Join Date
    08-02-2010
    Location
    Hampshire,England
    MS-Off Ver
    Office 365 and Office 2010
    Posts
    881

    Re: VBA: Copy and Past between different instances

    Link to cross-post
    If my solution worked (or not) please let me know. If your question is answered then please remember to mark it solved

    Computers are like air conditioners. They work fine until you start opening windows. ~Author Unknown

+ 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. copy the intersection of selected cells and past delimition then copy results to another
    By hassan khansa in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-07-2017, 04:57 PM
  2. [SOLVED] Copy from Excel to Reflection, simple Copy & past script ... Help Please : )
    By strik009 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-15-2015, 02:15 PM
  3. Help with copy past to last used row +1
    By Pat1009 in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 07-11-2015, 02:12 PM
  4. Copy and past
    By kuzna26 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-02-2014, 12:15 PM
  5. [SOLVED] need help with copy past vba
    By K-Ching in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-18-2014, 01:16 PM
  6. Copy and Past
    By skate1991 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-07-2012, 09:56 AM
  7. Copy and Past
    By Joe in forum Excel General
    Replies: 1
    Last Post: 08-16-2006, 09:10 PM

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