Block to excell cell - is it possible?

[JerryG]

Hello All.
I know it is posible to link objects with an excel file
but does anyone know if it is possible to link an autocad block
or object to a specific cell in excel?
Example; I want a hyperlink when clicked on in autocad (such as a valve) to not only open excel but go to that cell or sheet.:?
I was able to do this using DATALINK, however it does not let me link to a specific object - just the dwg:(

[rustysilo]

Sorry. No idea. It may not hurt to ask in one of the other forums as it isn't a Civil 3D specific question necessarily.
If you get no answers go check theswamp.org and maybe someone there can help.

[JerryG]

Thanks Rusty.
Ill give that a shot!

[LCE]

Set the hyperlink as excelfile.xls#excelcell
So, for Test.xls on my C:\ to link to cell A1 it would be
C:\Test.xls#A1

[JerryG]

Right on!:lol:
That worked perfect!
Thank You LCE and Rusty - thats why I love this forum.:D

[LCE]

Right on!:lol:
That worked perfect!
Thank You LCE and Rusty - thats why I love this forum.:D
No problem Jerry.
Glad I could help.

[JerryG]

Just in case anybody else is doing this
I also found out after doing more research that
you can connect to other sheets in excel
by typing #sheet1!a1 (sheet1 = your sheet name)
(a1 = cell you want to go to)

[rustysilo]

I believe there's a similar function if you want to connect to a completely different excel file as well.