URL Encoding (1 Viewer)

[alexfwalker81]

At the moment I have a database which churns out 4 columns of information into an Excel sheet. In this sheet, I have a formula which concatenates the information, and then uses a very useful Excel plugin called SEOTools, to create a hyperlink with all the necessary URL encoding.

Whilst this is functional, it has the disadvantage that the only computer that can generate the URLs is mine, as I am the only one with the plugin. It's also inelegant, and that bugs me more than having to encode URLs for people all the time. I'd like to cut out the middle-man and generate correctly encoded URLs straight from Access, but I don't think there's a built in function to do that, and I can't find an equivalent anywhere.

Can anyone point me in the right direction?

 

[theDBguy]

Do you really need a plug in in Excel? Doesn't it have a built-in command already? Just curious...

WorksheetFunction.EncodeUrl method (Excel)

Office VBA reference topic

docs.microsoft.com

In Access, it shouldn't be too hard to build a function to perform the URL encoding once you have all the rules in place.

HTML URL Encoding Reference

W3Schools offers free online tutorials, references and exercises in all the major languages of the web. Covering popular subjects like HTML, CSS, JavaScript, Python, SQL, Java, and many, many more.

www.w3schools.com

 

[alexfwalker81]

Do you really need a plug in in Excel? Doesn't it have a built-in command already? Just curious...

WorksheetFunction.EncodeUrl method (Excel)

Office VBA reference topic

docs.microsoft.com

In Access, it shouldn't be too hard to build a function to perform the URL encoding once you have all the rules in place.

HTML URL Encoding Reference

W3Schools offers free online tutorials, references and exercises in all the major languages of the web. Covering popular subjects like HTML, CSS, JavaScript, Python, SQL, Java, and many, many more.

www.w3schools.com

Annoyingly, no Excel doesn't! I'll have a look at w3 as I've always thought that there would be too many rules to mess about with, but now I think about it, that capitalisation thing I learned the other day might well suffice...

 

[Isaac]

Annoyingly, no Excel doesn't! I'll have a look at w3 as I've always thought that there would be too many rules to mess about with, but now I think about it, that capitalisation thing I learned the other day might well suffice...

Assuming you're using 2010?

 

[alexfwalker81]

Assuming you're using 2010?

Yes, frustratingly. I think I'll be making a request to get us on 365...

 

[alexfwalker81]

And now I'm feeling smug... here's how it's done Thanks to arnelgp for his original function which I've 'stolen with pride' and repurposed.

 

[theDBguy]

And now I'm feeling smug... here's how it's done Thanks to arnelgp for his original function which I've 'stolen with pride' and repurposed.

Hi. Glad to hear you got it sorted out. Good luck with your project.