View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default hyperlink format

I don't know if this function is available in Access, but:

=HYPERLINK("file:///C:\Documents and
Settings\User\Desktop\Book2.xls#Sheet2!B9")

Has the advantage that it will open the file if not already openned
--
Gary''s Student - gsnu200734


"SDH" wrote:

Can someone give me an example of a hyperlink to a specific cell in a workbook?
I want to put this hyperlink in Access so I can go directly to a cell in Excel
Thanks