+ Reply to Thread
Results 1 to 3 of 3

How to create a program that copy and paste between instances of excel???

  1. #1
    Registered User
    Join Date
    02-17-2011
    Location
    houston, tx
    MS-Off Ver
    Excel 2003
    Posts
    2

    How to create a program that copy and paste between instances of excel???

    Hi,
    I am new to programming and wanted some advice.
    The problem that I am facing is as follow: I have a simulation software that export to Excel. I am able to automate the export function of the simulation software of the via Excel VBA (call this ExcelA.xls). However, when the software export, it export to a new instance (ExcelB.xls). Thus I cannot do simple programming to activate in ExcelB.xls.

    What I want to do is copy the data (from say Sheet1) from this new instance (ExcelB.xls) and paste it into the (say Sheet1) of ExcelA.xls of the old instance.
    And finally close the new instance ExcelB.xls without saving.

    Does anyone know how to approach this problem?

    some examples would be great

    Thanks ahead

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,002

    Re: How to create a program that copy and paste between instances of excel???

    Try right clicking on the sheet tab and select "Move or Copy sheet". Experiment with it.

  3. #3
    Registered User
    Join Date
    02-17-2011
    Location
    houston, tx
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: How to create a program that copy and paste between instances of excel???

    The new instance does not recognize the old workbook (excelA.xls). I also wanted to do this in an automated way, so that the user doesn't have to do it.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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