Monthly Archives: March 2011

Getting CRM Right

If you read about Customer Relationship Management (CRM), you’ll undoubtedly learn of various software, implementation strategies, successful and failed outcomes, and other interesting information. Unfortunately, within this overload of facts and tidbits of information, we sometimes forget about what CRM … Continue reading

Posted in CRM | Tagged | Comments Off

Win32OLE and Ruby: working with cells and data

This post is part of a series. If you can’t understand what is detailed below, or can’t find the information you’re looking for, take a look at the index page. As explained previously, each Worksheet object Win32OLE uses contains many … Continue reading

Posted in Automation, Ruby | Tagged , , | 5 Comments

Win32OLE and Ruby: formatting worksheets

This post is part of a series. If you can’t understand what is detailed below, or can’t find the information you’re looking for, take a look at the index page. Now that we’ve crunched numbers and otherwise manipulated the data … Continue reading

Posted in Automation, Ruby | Tagged , , | Comments Off

Win32OLE and Ruby: working with worksheets

This post is part of a series. If you can’t understand what is detailed below, or can’t find the information you’re looking for, take a look at the index page. First things first Naturally, before you can use Win32OLE, you’ll … Continue reading

Posted in Automation, Ruby | Tagged , , | 4 Comments

Using Ruby and Win32OLE to manipulate Excel

In today’s business world, most data is presented in Excel format. However, working with Excel by hand can quickly become mind numbingly boring when it is reduced to repetitive actions such as copy and pasting, formatting, etc. This time would … Continue reading

Posted in Automation, Ruby | Tagged , , | Comments Off