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
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