May 9, 2013
I am ashamed to admit that I've only recently decided to start experimenting with Google Spreadsheets, and what I've discovered is that whatever allure or power Excel had over me due to the amazing things you could do with VBA scripting, is completely overshadowed by the awesomeness of the sorts of things you can do inside of Google Spreadsheets.
Keep Reading »
April 24, 2013
Lately, I've started to realize that I'm working very hard, but if someone asked me whether or not I feel that I'm working toward a larger purpose, I'd have to say that I really don't know. The current approach feels more like a machine-gun approach, where I'm just trying to accomplish whatever I can, and hope that it gets me where I want to be. That's not quite the way to achieve one's life goals. So I decided to create the ideal system from scratch.
Keep Reading »
April 19, 2013
Wouldn't it be nice to have the ability to just open up an Excel spreadsheet or a Word document, and without having to do anything at all, data gets read directly out of a text or CSV data file and loads directly into a chart embedded onto your spreadsheet or Word document? This is a form of automation using Office products, because if it's possible to automate the charting of data in Office, just think of the possibilities.
Keep Reading »
April 5, 2013
I’m coming to the end of my trial period with Microsoft Office 2013. Over the weeks it has been a reasonably solid experience with one or two quirks causing me no end of frustration. But do I want to upgrade? Do I want to pay for a subscription or full purchase or would I prefer to stick with Microsoft Office 2010, a suite that I've been using successfully for several years now? Indeed, should I even think of abandoning Microsoft in favour of an open source alternative?
Keep Reading »
September 19, 2012
It's no secret that I'm a total Excel fanboy. Much of that comes from the fact that I enjoy writing VBA code, and Excel combined with VBA scripts open up a whole world of possibilities. However, if you’re serious about using Excel to manage more of your life, then you should take the time to learn how VBA coding works. If you want to enhance your use of Excel, I invite you to follow along as I share a few of these designs.
Keep Reading »
September 17, 2012
Mobile phones are getting smarter by the day, but for some reason unbeknownst to man, they still tend to struggle with some of the most popular file types. It's a strange thought. For all its memory and processing power, your smart phone spits back a simple spreadsheet, as if it were the strangest thing to ever come across its plate. Playing memory-intensive video games on the other hand goes smoothly.
Keep Reading »
August 10, 2012
Isn't it amazing how something as simple as creating a chart can feel so complicated sometimes? In this article I'm going to show you how to use a really convenient and simple VBA object from Microsoft Office Web Components that lets you insert a Chart directly into a document, presentation or anything else where you can create VBA code to run it.
Keep Reading »
May 31, 2012
Word or Excel have numerous built-in shortcuts, and once you know them, they really are much faster to use than futzing around with the mouse and menus. The only question is: How do you get to know all of these shortcuts? Enter KeyRocket, a free application that teaches you keyboard shortcuts for Office interactively, as you work.
Keep Reading »
February 17, 2012
One of the most frustrating parts of working with VBA inside specific applications, is that it’s not always easy to get two applications to “talk” to each other. You can try for very quick transactions of information between applications is passing data to the clipboard, and then reading that information from the other application.
Keep Reading »
February 10, 2012
Whether or not you are a fan of Microsoft, one good thing that can be said about MS Office products, at least, is how easy it is to integrate each of them with one another. Just think of the power that comes from having incoming emails automatically generating new tasks or new calendar appointments, or having a completed task automatically email your boss with the updated status report from the task description.
Keep Reading »
February 9, 2012
During your work week, there are probably lots of times that you find yourself copying and pasting information from Excel into Word, or the other way around. This is how people often produce written reports based on data that’s accumulated and updated in an Excel spreadsheet. In this article, I’m going to dive a little more into the background VBA scripting that allows you to actually program connections between data in Excel and Word.
Keep Reading »
February 8, 2012
In the past, I’ve used email a whole lot in my batch jobs and other automated scripts, just like I’ve described in past articles. These are great for those times when you have a script that’s monitoring the health of a computer or the status of a specific process, but what if you want to automate sending emails from within Office products like Word or Excel?
Keep Reading »
June 24, 2011
Tabs are something which the guys at Redmond woke up late to. So far, it has escaped an introduction in MS Office; a feature I am sure many of you out there would want as a default. Microsoft Office plug-in Office Tab adds tabbed document support to Excel, Word, and PowerPoint.
Keep Reading »
December 20, 2010
Excel is an awesome data management tool. I use it a lot to store and organize the information I need to deal with on a daily basis. As I am working online, most of the time this information contains multiples URLs linking to web sources. Excel provides for plenty of flexibility to geeky, macros-savvy people. [...]
Keep Reading »
August 3, 2010
Yes, MS Office has a quite a few add-ins (plugins) of its own. They do a lot to enhance work productivity when it comes to extending the way we work with documents and presentations. Do you use any of the 3 Microsoft Word Plugins to Boost Your MS Word Experience? Then there was the one [...]
Keep Reading »
