link sheets in 2 separate excel instances

		Wrox Programmer Forums > Microsoft Office > Excel VBA > Excel VBA
link sheets in 2 separate excel instances

Excel VBA Discuss using VBA for Excel programming.

Welcome to the p2p.wrox.com Forums.

You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com

October 13th, 2006, 08:46 AM

dextert

Registered User

Join Date: Oct 2006

Posts: 1

Thanks: 0

Thanked 0 Times in 0 Posts

link sheets in 2 separate excel instances

It seems as though I am asking the impossible - but just in case - here's my problem:

I have 2 spreadsheets, each exists in a separate instance of Excel (to accommodate exchange of data via OLE interface), neither are saved.

However, they both have dynamic data in them.
I would like to compare the data from both spreadsheets in 1 single spreadsheet. Can I link one to the other, if so how?

Cheers
Tim

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Comparing two excel sheets	nbkn8ct	Excel VBA	5	August 28th, 2009 05:20 PM
Working with excel sheets	ramsri	VB How-To	1	October 25th, 2007 03:15 PM
Import From excel with n sheets	dbellavi	SQL Server DTS	1	September 11th, 2007 07:51 AM
Exporting Table to Excel Sheets	ayazhoda	Access VBA	11	April 5th, 2007 07:25 AM
MX2004 Can't Import Excel Sheets	koolkat67	Dreamweaver (all versions)	0	February 17th, 2006 06:00 PM