This Tool Will Save You Time & Money!

I just discovered this tool. I couldn't contain myself. It is going to save me so much time... and it's cheap!

Click Here

It will take your lists of keywords and add quotes and brackets around them. And if you do a lot adwords campaigns like I do, you'll understand it's value


Enjoy,

I can make an excel macro that does the same thing and it costs nothing.

Congratulations!

Can you explain how to do that to some of us who have never created an "excel macro that does the same thing and costs nothing"?

That would save me $10!

OK So Far I Got:

1) Go to Tools
2) Point to Macros
3) Click Visual Basic Editor

Now all I need is some code... If anyone's got it that would be great... Otherwise I'll continue to fumble through this until I've answered my own question.

I'll be back!

4) In the Project Explorer pane select VBAProject

5) From the Insert menu choose Module

It might be a while before my next entry... I think I might actually have to learn a new language...

I'm starting to think that the $10 might be worth it. Even if my time is only worth $10 per hour, I've already chewed that up...

Later,

OK, my time is to valuable. I'm dropping the $10!

I had a nice conversation with myself though.

I have no idea what that smilie represents, but I thought I would use it in this thread since it has proved to be filling but un-satisfying...

By all for now,

In Excel click on Tools-Macro-Visual Basic Editor
Open the ThisWorkBook Module
Place this code into the module:

Sub MakeKeyWords()
lr = ActiveSheet.Range("a65536").End(xlUp).Row
For x = 1 To lr
Cells(lr + x, 1) = """" & Cells(x, 1) & """"
Cells(lr * 2 + x, 1) = "[" & Cells(x, 1) & "]"
Next x
End Sub

Make a list of keywords in column A in any sheet
When done making the list click on Tools-Macro-Macros and run the MakeKeyWords macro

WHy leave the post up when we cant see the site?

As you may or may not have noticed you can no longer use anchor text in the body of a message (at least as of this post). This is to help curb the large amount of Spam of late. Posters must now put links that can be cut and paste rather than use anchor text as this will just be displayed as plain text.

-ok- thanks for the explanation

Thanks Mookie. That works slick.

I never got around to getting that tool that mysteriously disappeared up there. I'm glad I didn't, you saved me $10!

You guys must get a lot of spammers through here. I know it's a constant battle for the mods. I apologize for making you think I was spamming; wasn't my intention. The other 4-5 forums I hang out in have no problem with anchor text in the body...

Live and learn.

Again, thanks for the help Mookie.

Don't worry mlevenhagen. That live-links-no-anchor-text rule was put up very recently, and might come down again should the spamming stop. This forum is actually very laid back, tolerant and helpful, so be sure that no rule here was issued to aggravate us

I'm not worried. I'm here to learn and give back; not battle. It was a cool tool for those that don't have Excel... and really does save time.

Thanks for the encouragement!

Matt

Thank you I a thinking of doing some adwords. Good timing.

Thank mlevenhagen for this topic / code start and thanks mookie for actually completing. This file is on my desktop now. Very useful. Saves me sometime. Till now I had a macro in TextPad Do this for me, but this is a lil faster. I won't have to copy paste in Textpad to create this list. Just do it right there in Excel where you need it.



Do you have a Paypal based Donation page on yoru website ? Post it here and somepeople might donate, I will.