View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
david s. david s. is offline
external usenet poster
 
Posts: 9
Default follow hyperlink syntax

THIS QUESTION IS POSTED IN 'ACCESS DATABASE - GENERAL QUESTIONS' ALSO

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.