Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hyperlink Error in Excel when using #
Hi there!
I've been working on a macro in Excel that creates hyperlinks to files in a folder. The macro works fine, but I found that Excel can't manage hyperlinks when the folder name begins with"#" and it's located in the root directory. Something like this "D:\# DBs Nielsen" would cause Excel to generate an invalid hyperlink. I've checked and it's not a macro bug, Excel can't seem to work with that character. Anyone knows how to fix this? I really would like to solve this without changing the folder name as it's a shared server folder. THX in advance |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hyperlink Error in Excel when using #
The only fix I know is to stop using # in file names.
CerealKiller wrote: Hi there! I've been working on a macro in Excel that creates hyperlinks to files in a folder. The macro works fine, but I found that Excel can't manage hyperlinks when the folder name begins with"#" and it's located in the root directory. Something like this "D:\# DBs Nielsen" would cause Excel to generate an invalid hyperlink. I've checked and it's not a macro bug, Excel can't seem to work with that character. Anyone knows how to fix this? I really would like to solve this without changing the folder name as it's a shared server folder. THX in advance -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hyperlink Error in Excel when using #
I'm surprised that # would work anywhere within a file path...
The octothorpe is a reserved character in URIs, indicating a fragment identifier follows. As in: Ref: http://rfc.net/std0066.html#s3.5. In article , CerealKiller wrote: I've been working on a macro in Excel that creates hyperlinks to files in a folder. The macro works fine, but I found that Excel can't manage hyperlinks when the folder name begins with"#" and it's located in the root directory. Something like this "D:\# DBs Nielsen" would cause Excel to generate an invalid hyperlink. I've checked and it's not a macro bug, Excel can't seem to work with that character. Anyone knows how to fix this? I really would like to solve this without changing the folder name as it's a shared server folder. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hyperlink Error in Excel when using #
THX, but that is a little depressing.
Is there any alternative to hyperlink when using macros? Something like FILE in http. THX again "JE McGimpsey" wrote: I'm surprised that # would work anywhere within a file path... The octothorpe is a reserved character in URIs, indicating a fragment identifier follows. As in: Ref: http://rfc.net/std0066.html#s3.5. In article , CerealKiller wrote: I've been working on a macro in Excel that creates hyperlinks to files in a folder. The macro works fine, but I found that Excel can't manage hyperlinks when the folder name begins with"#" and it's located in the root directory. Something like this "D:\# DBs Nielsen" would cause Excel to generate an invalid hyperlink. I've checked and it's not a macro bug, Excel can't seem to work with that character. Anyone knows how to fix this? I really would like to solve this without changing the folder name as it's a shared server folder. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hyperlink Error in Excel when using #
You could open the file directly:
Option Explicit Sub testme() Dim wkbk As Workbook Set wkbk = Nothing On Error Resume Next Set wkbk = Workbooks.Open("d:\# DBs Nielsen.xls") On Error GoTo 0 If wkbk Is Nothing Then Beep MsgBox "not found" End If End Sub CerealKiller wrote: THX, but that is a little depressing. Is there any alternative to hyperlink when using macros? Something like FILE in http. THX again "JE McGimpsey" wrote: I'm surprised that # would work anywhere within a file path... The octothorpe is a reserved character in URIs, indicating a fragment identifier follows. As in: Ref: http://rfc.net/std0066.html#s3.5. In article , CerealKiller wrote: I've been working on a macro in Excel that creates hyperlinks to files in a folder. The macro works fine, but I found that Excel can't manage hyperlinks when the folder name begins with"#" and it's located in the root directory. Something like this "D:\# DBs Nielsen" would cause Excel to generate an invalid hyperlink. I've checked and it's not a macro bug, Excel can't seem to work with that character. Anyone knows how to fix this? I really would like to solve this without changing the folder name as it's a shared server folder. -- Dave Peterson |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hyperlink Error in Excel when using #
Depends on what you're trying to do - you can use Workbooks.Open if the
file is an XL Workbook. There are various ways to open text files or other Office document types. Your example doesn't really specify. OTOH, I'd really suggest avoiding reserved URI characters in file paths... In article , CerealKiller wrote: THX, but that is a little depressing. Is there any alternative to hyperlink when using macros? Something like FILE in http. THX again "JE McGimpsey" wrote: I'm surprised that # would work anywhere within a file path... The octothorpe is a reserved character in URIs, indicating a fragment identifier follows. As in: Ref: http://rfc.net/std0066.html#s3.5. In article , CerealKiller wrote: I've been working on a macro in Excel that creates hyperlinks to files in a folder. The macro works fine, but I found that Excel can't manage hyperlinks when the folder name begins with"#" and it's located in the root directory. Something like this "D:\# DBs Nielsen" would cause Excel to generate an invalid hyperlink. I've checked and it's not a macro bug, Excel can't seem to work with that character. Anyone knows how to fix this? I really would like to solve this without changing the folder name as it's a shared server folder. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hyperlink Error in Excel when using #
Thank You both.
I wanted to create an automated directory in excel with hyperlinks linking the files. Some people is always asking where some file is located. So I wanted to make things a easier for computer-handycapped people ;) THX again "JE McGimpsey" wrote: Depends on what you're trying to do - you can use Workbooks.Open if the file is an XL Workbook. There are various ways to open text files or other Office document types. Your example doesn't really specify. OTOH, I'd really suggest avoiding reserved URI characters in file paths... In article , CerealKiller wrote: THX, but that is a little depressing. Is there any alternative to hyperlink when using macros? Something like FILE in http. THX again "JE McGimpsey" wrote: I'm surprised that # would work anywhere within a file path... The octothorpe is a reserved character in URIs, indicating a fragment identifier follows. As in: Ref: http://rfc.net/std0066.html#s3.5. In article , CerealKiller wrote: I've been working on a macro in Excel that creates hyperlinks to files in a folder. The macro works fine, but I found that Excel can't manage hyperlinks when the folder name begins with"#" and it's located in the root directory. Something like this "D:\# DBs Nielsen" would cause Excel to generate an invalid hyperlink. I've checked and it's not a macro bug, Excel can't seem to work with that character. Anyone knows how to fix this? I really would like to solve this without changing the folder name as it's a shared server folder. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find Error, Hyperlink.. | Excel Discussion (Misc queries) | |||
Error using hyperlink | Excel Discussion (Misc queries) | |||
error in hyperlink | Excel Discussion (Misc queries) | |||
error in hyperlink | Excel Discussion (Misc queries) | |||
hyperlink error: "Cannot open the specified file" | Excel Worksheet Functions |