Coding the button problem in a UserForm

[John Fletcher]

Hello Everyone

This code below works great to take the user to a specific web page - so I am half way to my needed target. This code is associated with a button in a Userform.

Please Login or Register  to view this content.

I need just one last piece to send the user to a specific (target) (bookmark) in the html page...

Any thoughts will be greatly appreciated..

Best regards,

John

[N323100]

Maybe this?

Please Login or Register  to view this content.

[John Fletcher]

HI N323100,

Thanks for your reply -

Your suggestion ActiveWorkbook.FollowHyperlink Address:="your web link", NewWindow:=True Produced an (error)

The links in the web page are like this <a name=target1>Bob Smith</a>

Please Login or Register  to view this content.

[N323100]

What is the error?

[John Fletcher]

ActiveWorkbook.FollowHyperlink Address:="your web link", NewWindow:=True

is yellow


There are approx. 300 rows. and each row has a separate (bookmark) in the html page that I need to have the user taken to

John

[N323100]

try including "http://" on your link

[John Fletcher]

I do not understand...

Hard coding the hyperlink in the button does not allow any other html page to be loaded... Only the one coded in the button

When I mentioned the 300 rows - there are 300 different web pages and each has a location that the user needs to be taken to by way of the link in the cell i.e.: http://www.webpage.com/directory/file.html#target1 (this is changed to direct the user to the correct location I n the web page

As mentioned this code works great to pull the web page needed - I just need to direct the user to a target in the page

Please Login or Register  to view this content.

[N323100]

Would you mind to attach your project?

[John Fletcher]

sure - here is the form

I am using my wife's review page to practice on - and get the user to specific locations in that web page

Oh I forgot - select the Lookup button to launch the form - Sorry!

Also, I did modify the code to include the URL as you suggested and the code works to pull the web page - however no way to direct the user to specific location in the web page

[John Fletcher]

I have to head off to work... I will come back this afternoon to further look into solving this issue.....

Thanks in advance for your thoughts on this puzzle!

John

[John Fletcher]

Good Morning N323100

Thought I would reach out and discuss the file uploaded yesterday and see if you had any additional thoughts?

John