| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
hyperlink format
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
hyperlink format
Perfect......... worked great...... took me right to the cell!!
Now....... is there a way to update theinformation in the cell in Excell with information from the Access DataBase? "Gary''s Student" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Format Cells - Hyperlink | Excel Worksheet Functions | |||
| Automated Hyperlink format? | Excel Discussion (Misc queries) | |||
| How to remove Hyperlink without changing cell format? | Excel Worksheet Functions | |||
| How do I format text as a hyperlink in Excel | Excel Discussion (Misc queries) | |||
| Excel, turn off the hyperlink format when formula is @sum | Excel Worksheet Functions | |||
Linear Mode
