You can email me at macroking @ this domain.


November 18, 2005

Trying a new free macro/scripting program…

Filed under: Macros & Scripting — macroking @ 12:14 pm

So far I must say I am VERY impressed. Though far more sophisticated (and therefore, challenging to learn) than most Macro programs, I’m finding that the logic in its design, plus the built in help file, has me creating flawless macro scripts in nothing flat. You can get it a www.downloads.com by clicking here –> AutoHotKey

It will be helpful if you have at least some familiarity with programming languages and logic trees, since AutoHotKey can handle conditional events and If-Then logic as well as Do While loops. But the help file is very thorough and has lots of examples to help you along.

Stop using that mouse!

Filed under: Keyboard Shortcuts — macroking @ 10:19 am

One of the least efficient ways you can use a computer is to do everything by pointing and clicking. The mouse/trackball is a fantastic tool, but it is SLOW by comparison to the keyboard.

I often find myself hilighting words or phrases for editing, and until fairly recently I’ve always done this by mouse. Now occasionally I would use SHIFT and the arrow keys on the keyboard to select whole lines (SHIFT-UP or DOWN) or sometimes to increase my selection by a few characters (SHIFT-RIGHT or LEFT), but a friend of mine taught me a trick that is now an absolute staple for me.

November 17, 2005

A few favorite Excel tricks…

Filed under: Excel & Spreadsheets — macroking @ 10:34 am

You may or may not know about the CONCATENATE function in Excel. Basically for those who don’t, what it does is allow you to “stitch” things together from different cels. For example, if I were to put the formula:

=concatenate(a1,b1,c1,d1)

into a cel, the results would be the contents of those 4 cels (a1 through d1) all together in one cel. But, what if those cels each contained a word? The results might be messy, like this:

word1word2word3word4

What if I want spaces between the words? Well fortunately that’s easy… it would be something like this:

Page Generators - Kings of Crap?

Filed under: Blog & Site Automation — macroking @ 1:22 am

OK, you may or may not have heard of “page generation software”. If you build portal sites, well then OF COURSE you know about them. What are they you ask? Well in simplified fashion, they are programs that take a template created with HTML, and do a big “find & replace” job on them to replace certain placeholder words in the template (known as “tokens”) with the words you ACTUALLY want to be on the page. The thing is, they will do this for you on thousands of individual key words, resulting in thousands of individual pages being created in minutes or even seconds! There are loads of them on the market right now, but the one I happen to be using most is called Traffic Equalizer and I like it quite a bit. However, despite what the sales claims are, the program itself will NOT earn you any traffic at all. it is merely a tool that must be part of an overall plan for developing and marketing your site(s).

Greetings from the King!

Filed under: Uncategorized — macroking @ 12:55 am

Well, ok, so it’s really AUTOMATION that’s King, not me personally, but I take whatever accolades I can get! ;)

So, what’s this little corner of the net about? It’s all about speed, baby. The faster and more efficient I can work, the better off my life in general (not to mention my bank balance!) gets. You’ve probably all heard the saying “work smarter, not harder” before, but how many people really put that into practical use? That’s what this place is here for.

« Previous Page