follow hyperlink to excel cell with specific value

[david s.]

i am able to use FollowHyperlink to open an excel file, and go to a specific
cell, but i want to go to a cell with a specific value, with that value being
determined based on a selection (item number) made on an Access form.
this is the code i use now in the dblclick event of a text box populated
with item numbers.

Application.FollowHyperlink "C:\SCHEDULE.xls#'ITEM LIST'!H" & [Item Number]

this would work fine if the row numbers coincided with the item numbers, but
they don't and i don't want to re-arrange them (1000 rows, 17 columns, many
formulas) so i want the syntax for going to a cell based on it's value.

 

[Tom van Stiphout]

On Sat, 23 Aug 2008 09:56:00 -0700, david s.

I think that's more than you can ask of FollowHyperlink.
Your next best option may be to use Automation, so you can essentially
"drive" Excel and make it do anything you can do yourself. That's a
big topic to read up on. Keywords: Excel Automation
CreateObject("Excel.Application")

-Tom.
Microsoft Access MVP