Thread: Put cell value from another workbook into a variable
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
rdshadden rdshadden is offline
external usenet poster
  
Posts: 1
Default Put cell value from another workbook into a variable

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

Reply With QuoteReply With Quote