John Walkenbach has a routine that can get values from a closed workbook:
http://j-walk.com/ss/excel/eee/eee009.txt
Look for either: GetDataFromClosedFile or GetValue.

And you could also just build a formula in an empty cell, retrieve the value and
then clean up that helper cell.

rdshadden wrote:

I want my visual basic code to get the value of a cell in another
workbook and put into a variable. Here is an example that does not
work:

Fund1Shares = "'E:\Finance\[Fund.xls]Fund'!$B$3"

When I write the value of Fund1Shares to a message box I get
'E:\Finance\[Fund.xls]Fund'!$B$3 and the not the value in $B$3

Any help would be appreciated.

--
rdshadden
------------------------------------------------------------------------
rdshadden's Profile: http://www.excelforum.com/member.php...o&userid=34778
View this thread: http://www.excelforum.com/showthread...hreadid=546595

--

Dave Peterson