Page 1 of 2 12 Last
  • Jump to page:
    #1
  1. Contributing User
    SEO Chat Discoverer (100 - 499 posts)

    Join Date
    Nov 2004
    Location
    WI, USA
    Posts
    154
    Rep Power
    15

    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,
    Last edited by Jasontnyc; Dec 2nd, 2004 at 04:12 AM.
  2. #2
  3. No Profile Picture
    Contributing User
    SEO Chat Discoverer (100 - 499 posts)

    Join Date
    Mar 2003
    Location
    The plywood state
    Posts
    366
    Rep Power
    17
    I can make an excel macro that does the same thing and it costs nothing.
  4. #3
  5. Contributing User
    SEO Chat Discoverer (100 - 499 posts)

    Join Date
    Nov 2004
    Location
    WI, USA
    Posts
    154
    Rep Power
    15
    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!
  6. #4
  7. Contributing User
    SEO Chat Discoverer (100 - 499 posts)

    Join Date
    Nov 2004
    Location
    WI, USA
    Posts
    154
    Rep Power
    15
    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!
  8. #5
  9. Contributing User
    SEO Chat Discoverer (100 - 499 posts)

    Join Date
    Nov 2004
    Location
    WI, USA
    Posts
    154
    Rep Power
    15
    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,
  10. #6
  11. Contributing User
    SEO Chat Discoverer (100 - 499 posts)

    Join Date
    Nov 2004
    Location
    WI, USA
    Posts
    154
    Rep Power
    15
    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,
  12. #7
  13. No Profile Picture
    Contributing User
    SEO Chat Explorer (0 - 99 posts)

    Join Date
    Jan 2004
    Posts
    78
    Rep Power
    0
    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
  14. #8
  15. Contributing User
    SEO Chat Discoverer (100 - 499 posts)

    Join Date
    Sep 2004
    Location
    Chicago, IL
    Posts
    116
    Rep Power
    15
    WHy leave the post up when we cant see the site?
  16. #9
  17. No Profile Picture
    SEO Chat Skiller (1500 - 1999 posts)

    Join Date
    Jul 2004
    Location
    St. James Gate
    Posts
    1,988
    Rep Power
    18
    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.
  18. #10
  19. Contributing User
    SEO Chat Discoverer (100 - 499 posts)

    Join Date
    Sep 2004
    Location
    Chicago, IL
    Posts
    116
    Rep Power
    15
    -ok- thanks for the explanation
  20. #11
  21. Contributing User
    SEO Chat Discoverer (100 - 499 posts)

    Join Date
    Nov 2004
    Location
    WI, USA
    Posts
    154
    Rep Power
    15
    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.
  22. #12
  23. http://tinyurl.com/cz56g
    SEO Chat Mastermind (5000+ posts)

    Join Date
    Sep 2004
    Location
    D0RDRECHT NL
    Posts
    6,063
    Rep Power
    31
    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
    ...please help me w/ the real Redscowl Bluesingsky...how2 check backlinks...now postin' @ SEO Refugee ...
    <`)~ LOL now that I finally have a paypal account, I'm charging 19,- for SEO advice via PM. Seriously...
  24. #13
  25. Contributing User
    SEO Chat Discoverer (100 - 499 posts)

    Join Date
    Nov 2004
    Location
    WI, USA
    Posts
    154
    Rep Power
    15
    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
  26. #14
  27. No Profile Picture
    Contributing User
    SEO Chat Discoverer (100 - 499 posts)

    Join Date
    Aug 2004
    Posts
    140
    Rep Power
    16
    Originally Posted by Mookie
    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
    Thank you I a thinking of doing some adwords. Good timing.
  28. #15
  29. No Profile Picture
    Contributing User
    SEO Chat Adventurer (500 - 999 posts)

    Join Date
    May 2004
    Location
    Chandigarh, India
    Posts
    516
    Rep Power
    15

    Smile


    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.
    Web Site Promotion India - Web Site Design India - Buy SiteWideLinks : $9.99 Links - PM Me if you need - Call 1.877.822.0875 for all kinds of Web Design, SEO - Link Building - Directory Submission Services.
Page 1 of 2 12 Last
  • Jump to page:

IMN logo majestic logo threadwatch logo seochat tools logo