D
david s.
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.
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.