Run-Time error 5824 - insufficient memory or disk space.

[DaveW]

I have a VB macro which converts text with a document extension to hyperlinks.
I keep getting the above run-Time error when I pass the text variable
through as a parameter. I have checked the parameter variable is being passed
through correctly. Can anybody give me clue to why this has started to
happen in Office2007?
a snippet from the code below the second Selection.Hyper...statemement
works the first causes the error:-

If LinkType = "H" Then
Selection.Hyperlinks.Add Anchor:=Selection.Range,
Address:=FileString, TextToDisplay:=FileString
Selection.Hyperlinks.Add Anchor:=Selection.Range,
Address:="c:\thisworks.txt", TextToDisplay:="thisworks"

 

[Nimrod]

Hi,
You need to write it like this:

Selection.Hyperlinks.Add Anchor:=Selection.Range, Address:="" & FileString
& "", TextToDisplay:="" & FileString & ""

 

[glakshman]

This is very useful for me. Thanks a lot.

Hi,
You need to write it like this:

Selection.Hyperlinks.Add Anchor:=Selection.Range, Address:="" & FileString
& "", TextToDisplay:="" & FileString & ""