macro - creating URLs

[morgonzola]

hey everyone,

i'm trying to create a macro that will put together some URLs for me. i haven't gotten it down - i'm still new at this.

i've got three columns and i have two pieces of code that fit between the three columns.. so it's like this:

columnA + code1 + column B + code2 + column C

the tricky part is that column B and column C may have spaces, which need to be replaced with a + (plus sign). (i used "While Not IsEmpty" for these.)


i'd like to get the new URL to be put into columnE..

my code isn't working - it's my first stab at it. i'm copying it below (and i attached it as a txt file). i'd appreciate any help.. and if you can keep comments in the code then i'll know where i went wrong.


(I would be placing my cursor into column C - which will be the active cell. There are comments beside each step.)

Please Login or Register  to view this content.

[morgonzola]

maybe i'm not being clear - it's not as hard as it seems, i know that i'm just missing something.

so, what i'm looking for is this:

if i have this in my worksheet with these values:
columnA = http://www.excel.com/
column B = help forum
column C = programming macro

then, code1 = ?a=1=
code2 = &b=5=

i want my end result to be placed into a brand new column (like columnE):
http://www.excel.com/?a=1=help+forum...gramming+macro


does this make sense? i'd really appreciate any help.

[VBA Noob]

Please wrap your code. See Forum rules below

VBA Noob

[morgonzola]

sorry.. i wrapped the code in my original post.

last note - the "code1" and "code2" will be the same throughout the whole URL generation - only the values in columns A - C are changing.