If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Copy data between 2 Excel for comparison
Hello,
I requested by CyberTaz to ask my question again and describe the situation I have, so here it's : In our place we have a software. That software has a small feature "Export to Excel". Whenever I operates the "Export" I got new instance of Excel with data. Most of the time I must compare data between two reports I got in Excel. So, on my desktop there are two instances of Excel, instead of doing the same steps over and over again ( Select all cells, Copy, go to other Excel, Paste the data and etc... ) I would like to write a macro that will do the sisyphean work. My question is : What should I write in VBA so I can copy data from one instance of Excel to another ? ( My last option will be to write 2 macros, one for copy the data and save it on the disk. The second macro will load the saved file and compare the data with the other report ) Is anyone has better solution ? Thanks. |
#2
|
|||
|
|||
I'm not sure it's better, but I'd save the workbook in one instance, close that
instance and reopen that workbook in the first instance. Then have your macro process the compare. Heck, if you always save the first workbook with the same name, you could just save the first workbook, close that instance and run your macro--it could open that (just saved) workbook and do all the processing. Boba wrote: Hello, I requested by CyberTaz to ask my question again and describe the situation I have, so here it's : In our place we have a software. That software has a small feature "Export to Excel". Whenever I operates the "Export" I got new instance of Excel with data. Most of the time I must compare data between two reports I got in Excel. So, on my desktop there are two instances of Excel, instead of doing the same steps over and over again ( Select all cells, Copy, go to other Excel, Paste the data and etc... ) I would like to write a macro that will do the sisyphean work. My question is : What should I write in VBA so I can copy data from one instance of Excel to another ? ( My last option will be to write 2 macros, one for copy the data and save it on the disk. The second macro will load the saved file and compare the data with the other report ) Is anyone has better solution ? Thanks. -- Dave Peterson |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Copy data between 2 instances of Excel | Boba | General Discussion | 5 | February 17th, 2005 11:46 PM |
Data from Excel to Access | Database Design | 2 | August 20th, 2004 12:53 PM | |
Excel Worksheets | Richard | General Discussion | 2 | July 8th, 2004 04:34 AM |
Merging Excel Data into Word Document | Debra Dalgleish | Worksheet Functions | 1 | February 16th, 2004 12:15 AM |
Copy Data to Sheet2 if cell in Sheet1 is not blank | Max | Worksheet Functions | 0 | November 10th, 2003 03:53 PM |