How to read external cell?
 

I want to read a specific cell value from a closed workbook. How can I
do this in VBA? Tried soo many different things and it just doesnt
work...

Cheers,

Matts


--
mattsvai
------------------------------------------------------------------------
mattsvai's Profile: http://www.excelforum.com/member.php...o&userid=31134
View this thread: http://www.excelforum.com/showthread...hreadid=509152

How to read external cell?
 

Hi Mattsvai,

See John Walkenbach at:

http://www.j-walk.com/ss/excel/tips/tip82.htm


---
Regards,
Norman



"mattsvai" wrote in
message ...

I want to read a specific cell value from a closed workbook. How can I
do this in VBA? Tried soo many different things and it just doesnt
work...

Cheers,

Matts


--
mattsvai
------------------------------------------------------------------------
mattsvai's Profile:
http://www.excelforum.com/member.php...o&userid=31134
View this thread: http://www.excelforum.com/showthread...hreadid=509152

How to read external cell?
 

2 thumbs up :)


Thank-you


--
mattsvai
------------------------------------------------------------------------
mattsvai's Profile: http://www.excelforum.com/member.php...o&userid=31134
View this thread: http://www.excelforum.com/showthread...hreadid=509152

How to read external cell?
 

That was provided last Friday (3 Feb):

========/answer to post on 3 Feb/===========


Tom and other's also suggested some other approachs.

Here is another one although this would be slower.

http://www.j-walk.com/ss/excel/tips/tip82.htm
A VBA Function to Get a Value From a Closed File


--
Regards,
Tom Ogilvy


"mattsvai" wrote in
message ...

actually "Record" and "Sheet1" was used for hypothetical situation and
not a mistake.. thanks for pointing it out though.

I found out from Toms post in another thread that the workbook()
function cannot include paths of closed workbooks in VBA... so I guess
its a NO GO.


--
mattsvai

===========/End/=======================


"mattsvai" wrote in
message ...

2 thumbs up :)


Thank-you


--
mattsvai
------------------------------------------------------------------------
mattsvai's Profile:
http://www.excelforum.com/member.php...o&userid=31134
View this thread: http://www.excelforum.com/showthread...hreadid=509152