set focus to an excel cell from word

[hanyu.chuang]

Let's say I have a simple excel.workbook object in word VBA, like

set someWorkbook = GetObject("somefile.xls")

is it possible to write a simple sub that opens Excel, opens up the
somefile.xls, and set user focus to a specific cell, like

SetFocusToExcelCell "B5", someWorkbook

????

 

[Doug Robbins - Word MVP]

See the article "Control Excel from Word" at:

http://www.word.mvps.org/FAQs/InterDev/ControlXLFromWord.htm


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP