gmooney
Active Member
- Joined
- Oct 21, 2004
- Messages
- 254
- Office Version
- 365
- Platform
- Windows
Hi,
I have the following code (which currently gives me an error) that launches a website from a list of URLs in my spreadsheet.
The code will launch the URL, which then requires me to login to the site and then go to the proper URL but I get an error message.
However, if I simply go click on the URL from the list of URLs it launches, has me sign in and delivers the results without the error message. Another words everything about the URL is fine when simply clicked on.
But firing the URL from this macro produces the error on the website.
Any ideas?
Sub StoryBU_Change()
HyperLink_Index = Range("LinkedCellStory")
If Range("URLStory").Offset(HyperLink_Index - 1, 0).Hyperlinks(1).Name <> "" Then
Range("URLStory").Offset(HyperLink_Index - 1, 0).Hyperlinks(1).Follow NewWindow:=False, AddHistory:=True
End If
End Sub
I have the following code (which currently gives me an error) that launches a website from a list of URLs in my spreadsheet.
The code will launch the URL, which then requires me to login to the site and then go to the proper URL but I get an error message.
However, if I simply go click on the URL from the list of URLs it launches, has me sign in and delivers the results without the error message. Another words everything about the URL is fine when simply clicked on.
But firing the URL from this macro produces the error on the website.
Any ideas?
Sub StoryBU_Change()
HyperLink_Index = Range("LinkedCellStory")
If Range("URLStory").Offset(HyperLink_Index - 1, 0).Hyperlinks(1).Name <> "" Then
Range("URLStory").Offset(HyperLink_Index - 1, 0).Hyperlinks(1).Follow NewWindow:=False, AddHistory:=True
End If
End Sub