I have supplier name in excel.. I need a VBA to the Supplier Web URL

**Kiran Kurapati** · 05-16-2013, 11:28 AM

Hi All

I have a list of suppliers in column A I need a VBA which should help me in fetching the Supplier WEB Url in the next column when I run the code..

Is this possible... can some one kindly help

Regards
Kiran Kumar

**MaczaQ** · 05-16-2013, 03:13 PM

maybe You will need only simple join of texts

Consider to attach some expamle workbook with dummy data.

example of join

  partURL ="http://someaddress.com?user="
  For Each cl in columns("A").specialcells(2)
    cl.offset(,1).value = partURL & cl
  next cl

**Kiran Kurapati** · 05-17-2013, 01:25 AM

Hi Mac,

Please find the enclosed excel sheet with some company names....

when I run macro against column B I need get the supplier Web address (Url) in the Column C

Thanks for your precious time

Regards
Kiran Kumar