| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA to refer to a cell in a different file
Hi, Really stupid question, but I'm not sure of the syntax to refer to cell in another worksheet from within VBA. I'm trying: temp = C:\Documents and Settings\Daz\Desktop\HYP Screene v11.xls[ShareData]!L3 or temp = '[HYP Screener v11.xls]ShareData'!L3 and neither seems to work. The file I'm working on is in the same di as the file I'm trying to access. Can anyone point me in the righ direction? Cheers, Da -- dazma ----------------------------------------------------------------------- dazman's Profile: http://www.excelforum.com/member.php...fo&userid=2590 View this thread: http://www.excelforum.com/showthread.php?threadid=49268 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how i can refer to cell in long formula go to another file | Excel Discussion (Misc queries) | |||
| How make hyperlink refer to cell content rather than cell address. | Excel Discussion (Misc queries) | |||
| some kind of meta-way to refer to sheet and file names in Excel? | Excel Discussion (Misc queries) | |||
| refer to other xls file | Excel Worksheet Functions | |||
| Save file, refer filename to cell and change directory | Excel Programming | |||
![dazman[_14_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
