1) this works:
(remove the space after h)
but not this:
instead i got either one of these errors:
why is this so? both are normal websites so theoretically it should work?
2) i found this solution on stackoverflow which is able to open my website
Shell "explorer ""Indicator"""
could u explain the syntax to me? i tried googling for the shell syntax explanation but they werent helpful for my context
what does 'explorer' refer to? im sure that it isn't explorer.exe, as the code opened the website in my default browser which is firefox
why are there double quotes ("") for the website?
lastly, i used the shell code above for each of the 4 websites that i want to open. however, the websites did not open in the order of the shell code. is there a way to make them open in order?
for eg
Shell "explorer ""website1"""
Shell "explorer ""website2"""
Shell "explorer ""website3"""
firefox opened websites 1 and 3 followed by website 2
Code:
thisworkbook.FollowHyperlink "https://www.google.com"
but not this:
Code:
ThisWorkbook.FollowHyperlink "https://www.bi.go.id/en/statistik/indikator/IndONIA.aspx"
instead i got either one of these errors:
why is this so? both are normal websites so theoretically it should work?
2) i found this solution on stackoverflow which is able to open my website
Shell "explorer ""Indicator"""
could u explain the syntax to me? i tried googling for the shell syntax explanation but they werent helpful for my context
what does 'explorer' refer to? im sure that it isn't explorer.exe, as the code opened the website in my default browser which is firefox
why are there double quotes ("") for the website?
lastly, i used the shell code above for each of the 4 websites that i want to open. however, the websites did not open in the order of the shell code. is there a way to make them open in order?
for eg
Shell "explorer ""website1"""
Shell "explorer ""website2"""
Shell "explorer ""website3"""
firefox opened websites 1 and 3 followed by website 2
Last edited by a moderator: