Ok I am very new to VBA stuff
I am trying to understand this stuff. if i want a macro to follow a hyperlink , i entered this
Sub 1()
ActiveWorkbook.FollowHyperlink
Now when i do this i get the following string of options:
FollowHyperlink(Address As String,
What would be the string for hyperlinking to another xcell file on the desktop
umrebelfan69@yahoo.com
umrebelfan69,
This is the string needed for a file on your desktop. I had thought that adding "Application.DisplayAlerts = False" before and turning it to true afterwards would stop the error message about hyperlinks being harmful to your computer but it didn't and perhaps someone else here might be able to guide you in that respect
Hope this hepls
Sub I() ActiveWorkbook.FollowHyperlink ("C:\Documents and Settings\username\Desktop\filename.xls") End Sub
Seamus
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks