| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Reading Data from another workbook... depending on variable in a cell? | Excel Discussion (Misc queries) | |||
| Running a variable macro when any value is entered into a variable cell | Excel Programming | |||
| Linking a cell to another workbook cell based on a variable name | Excel Discussion (Misc queries) | |||
| Can a workbook variable be set by clicking the workbook? | Excel Programming | |||
| Can a workbook variable be set by clicking the workbook? | Excel Programming | |||
Threaded Mode
