troubleshooting Question

Excel macro to create string from cell value

Avatar of hendrkle
hendrkle asked on
Microsoft ExcelVB Script
2 Comments1 Solution272 ViewsLast Modified:
Dear Experts,

I have found the following code to open a website for me at http://mywebsite.

Sub Website_Open()
    Dim i As Long
    Dim IE As Object
    Dim objElement As Object
    Dim objCollection As Object
 
    Set IE = CreateObject("InternetExplorer.Application")
 
    IE.Visible = False
 
    IE.Navigate "http://mywebsite"
    
End Sub

I would like to change the address string to concatenate with the currently selected cell and a static value of "}". For example, when the currently selected cell value is (without the quotation marks) "product1", I would like to URL to become:

http://mywebsite + product1 + }

so, altogether: "http://mywebsiteproduct1}" is what I am looking for.

Any guidance is much appreciated!

Thanks


   
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 2 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros