Subscribe now and choose from over 30 free gifts worth up to £49 - Plus get £25 to spend in our shop
I'm trying to set up a master workbook that links to various sheets from other workbooks. Using OLE seems the obvious way but how do I control which part of the source data is displayed? FWIW the function bar currently shows
=Excel.Sheet.8|'C:\filename.xls'!''''
so I'm guessing there are a few extra parameters I can fiddle with after the filename (& what's the .8 all about?). I'm clearly not googling for the right stuff cos all I get is noddy info on worksheets.
TIA
Not quite what I'm looking for - I'd like to mirror the data & formatting both ways so OLE makes more sense.
If you do = and then click the cell where the data is it should just pull it through no?
Never tried to link two workbooks via OLE, so no idea if it's possible.
Personally I'd use VBA as it's very easy to manipulate any number of WBs or WSs at the same time.
From what I've read uwe-r might be right if you have both workbooks open in the same excel window.
Don't use external links.
This would make more sense
Personally I'd use VBA as it's very easy to manipulate any number of WBs or WSs at the same time.
[url= http://www.qlikview.com/uk ]Qlikview[/url] would make even more - it's great for sucking data out of disparate sources and combining/manipulating it. If you [i]really[/i] need to you can then get it to spit out a .csv file, but it's also pretty good for making reports with.
Rob, ex-Excel developer; born again Qlikview evangelist 
Thanks folks - guess its VBA time then...