View Single Post
 
Old 07-27-2014, 11:24 PM
tmaster81 tmaster81 is offline Windows 8 Office 2007
Novice
 
Join Date: Jul 2014
Posts: 5
tmaster81 is on a distinguished road
Default Help with external links using Web query/Add-in/VBA Macro

Hi,

I need some help with something, Not sure if this can be done with a macro/VBA/Add-ins/ Web Query or some other way.

what I want is to extract the link (which is a shortcut ... column B) to be decoded into the next cell with the actual link.

For now I do this manually. Is there a way in which this could be done with anything in the back-end?

I want to do something link what is done in http://www.xposition.co.uk/bitly-decoder.asp

Attached is the excel... Please help me with this...

Thanks,
Tejas
Attached Files
File Type: xlsx Book1.xlsx (12.5 KB, 9 views)
Reply With Quote