Activating link on Intranet home page
I am working on a project which is Excel based but part of which links to another internal system, a Purchase Order creation platform.
I want to be able to open the PO Platform from the Excel sheet, ideally without going to the Intranet home page first.
Our Intranet home page has a button which links to the PO Platform and I can copy the link from it.
When I use that as a hyperlink in Excel it does not behave the same as when clicking it direct from the Intranet.
Using the link on the Intranet just takes you to the PO platform with single sign on authentication whereas using the hyperlink in Excel shows an error saying user hasn't logged off and then goes to the login window for the platform. I have spoken to our IT department and apparently it is to do with multiple logins for the PO platform being disabled and we do not want to re-enable it; they have tried in the past and it caused other issues.
So, I am thinking I can maybe set a macro that runs when the hyperlink is clicked. The macro would navigate to the Intranet home screen and "click" the button. The button is stored within a table on the home screen and has a specific jpg as a symbol.
Can this be done?
Thanks
Rob Henson
I want to be able to open the PO Platform from the Excel sheet, ideally without going to the Intranet home page first.
Our Intranet home page has a button which links to the PO Platform and I can copy the link from it.
When I use that as a hyperlink in Excel it does not behave the same as when clicking it direct from the Intranet.
Using the link on the Intranet just takes you to the PO platform with single sign on authentication whereas using the hyperlink in Excel shows an error saying user hasn't logged off and then goes to the login window for the platform. I have spoken to our IT department and apparently it is to do with multiple logins for the PO platform being disabled and we do not want to re-enable it; they have tried in the past and it caused other issues.
So, I am thinking I can maybe set a macro that runs when the hyperlink is clicked. The macro would navigate to the Intranet home screen and "click" the button. The button is stored within a table on the home screen and has a specific jpg as a symbol.
Can this be done?
Thanks
Rob Henson
Roy Cox
maybe you can add the code to the SheetFollowHyperlink event, but you would need to know how to reference the button
ASKER
That was the plan, using the FollowHyperlink event, but I need the code to reference the button.
You will need some information about the button, maybe the name and I think it will also depend on which browser you are using.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
How do I identify the Anchor for the button?
I can see in the Source where it puts the image into a table, along with other items, but can't see how to identify it.
When I right click on the button and View Source or Inspect element it shows lots of what likes html text but there are a lot of mentions of Java and css script. Does this mean the page is Java script based, if that's a thing?
I can see in the Source where it puts the image into a table, along with other items, but can't see how to identify it.
When I right click on the button and View Source or Inspect element it shows lots of what likes html text but there are a lot of mentions of Java and css script. Does this mean the page is Java script based, if that's a thing?
ASKER
When I step through the script there appears to be only two Anchors, "Home" and " ".
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Just used SendKeys to maximise the window.
ASKER
Many thanks for the guidance.
Pleased to help, I would suggest trying to find an alternative to SendKeys, I'll look myself
ASKER
Yeah, wasn't keen on using SendKeys so would appreciate an alternative.