Help with external links using Web query/Add-in/VBA Macro

tmaster81 · #1 07-27-2014, 11:24 PM

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Macro to update ole links not working	kisa500	PowerPoint	7	02-05-2013 03:52 AM
Macro - Get External Data From Web	Wries	Excel Programming	1	10-31-2012 08:00 AM
word macro that reformats embedded links in a doc	EricT	Word VBA	7	09-12-2012 04:13 PM
External/Embedded links to excel	lucas	Word	3	03-30-2012 01:47 PM
Macro to loop in subfolders, change links, export xml data	Catalin.B	Excel Programming	2	09-08-2011 11:37 PM