I was just watching this video,
http://tssupport.com/addons/owndata/movies/excel.shtml
Quotemanager is set to reference demo.xls and rncn format is used as the symbol name. How do you reference a specific sheet?
Universal DDE to Excel
- Andrew Kirillov
- Posts: 1589
- Joined: 28 Jul 2005
- Has thanked: 2 times
- Been thanked: 31 times
- Contact:
Dear cael,
To reference a specific sheet in an Excel book you should use syntax as following:
To reference a specific sheet in an Excel book you should use syntax as following:
Code: Select all
=EXCEL|'[YourBookName.xls]YourSheetName'!*
- Andrew Kirillov
- Posts: 1589
- Joined: 28 Jul 2005
- Has thanked: 2 times
- Been thanked: 31 times
- Contact:
- Marina Pashkova
- Posts: 2758
- Joined: 27 Jul 2007
i use now (see screenshot):using the following format:
=EXCEL|'[YourBookName.xls]YourSheetName'!*
=EXCEL|'[TWS_id20.xls]sheet2'!*
Is it necessary to receive the quotes in Excel over DDE, or can they also received over ActiveX? So, is it quite immaterial how Excel receives quotes in a cell?
Thanks
- Attachments
-
- dee3.PNG
- (29.25 KiB) Downloaded 978 times
- Marina Pashkova
- Posts: 2758
- Joined: 27 Jul 2007