I was watching a favorite YouTube channel and the Jack-of-all-trades Host said, “I find do my best work when I am organized”. For most of us not only do you do your best work but I will wager you are more productive, experience less frustrations and walk away from the task happier.  I know I do. I developed the SideKick to put my most useful tools at my fingertips, to promote idea and next step capture.  There is no doubt that some of the tools are pretty specifc to VBA consulting/Freelancing but, some are very general and could be of use by any Excel Desk Jockey.  I could have added a menu item for the sidekick but I wanted it right out in front of me.  I also wanted to be a perpetual work in process, always evolving.

SideKick has been personalized for my needs, it is still a great start for you to develope your own version.

The ToDo Manager will help you keep Track of the many projects you are juggling. You can learn more Here

The Notion Tool’s
purpose is to help you capture those notions/ideas before they are forever lost You can learn more Here

VBA Shortcode
creates HTML for code snippets for insertion into my website: to see click an example click Here

Website Control is a website that contains critical CSS code and lsits all the pages in my website.  This way i can make sure changes/updates are applied to all pages.

Capture Emails List
captures the email of my website Dowload vistors and stores them in a database so I can inform them of updates

The File Backup Tool is used to automatically back up
Files you designate as key critical.  You can learn
more here

 

VBA Short Code Tool
1 Sub GetTBName()
2 ' use selection.ShapeRange.Name to get the name
3 Dim shp As Shape, i as integer
4
5 With ActiveDocument
6 For i = 1 To .Shapes.Count
7 Debug.Print .Shapes(i).Name, .Shapes(i).TextFrame.TextRange.Text
8 If .Shapes(i).Name = "Text Box 1000" Then
9 .Shapes(i).Name = "MyPageNo"
10 End If
11 Next i
12 End With
13
14 End Sub

Code Snippets by Ray Mills
This is my solution - Always thoroughly test and retest your code!!

 

 

Inserting VBA code into my website used to be a real pain. [ I try whenever possible to avoid using plugins]. Take some VBA code and drop it into the tool. It will then convert it to some ‘shortcode’ HTML that produces the tidy and professional output like the example to the to the left.

File Backup Tool

The file backup tool backs up your key critical files. Simple: select the files you want baked up then select a destination to where they should be backed up to.  When it is run the the tool determins if files have been revised since their last backup and it identifies them with the red ball. hit the backup button and only those files necessay are backed up.  I use an external disk drive.
A solid backup strategy can save you hours/days of work if tragedy happens.

If you are interested in getting a free copy of the Side Kick or any of the free tools discussed above please use the contact form in the right column of this page.

If you enjoyed this post or found it helpful andl would like to say hello and buy me a cup of coffee
Click here

Raymond Mills, M.B.A., M.S.  has spent over 20 years of his career as Accountant, Investment Bank and Credit Card Technical Auditor/ Data Analyst.  His specialty was using Excel to get Big Databases including Teradata, Oracle,  Squel Server and Sybase to give up their secrets. Ray has said “I love nothing better than using VBA to unleash the power of Microsoft Office.” You can contact Ray @ 484 574-3190 or by emailing him Here

If you have a challenge with Excel, Access or Word and would like to speak with Ray,   You can get his contact details by clicking here: Contact Me