Sonny’s Blog

Exporting data from Access to Excel. I’ve done this the other way around, that is, exporting data from Excel to Access, but this is the first time I’ve done it like this.

One of the requirements is for charts to be created in the Excel document.

I am creating a custom class to handle Excel documents. I realize that the ADO has Excel classes, but I have particluar operations that I need to do. So instead of  opening and closing an Excel application object for each and every operation, I’ve built a class called clsExcel that opens an Excel application from within Access. When initialized, the OpenExcelDoc(ExcelFileName) method is used to open a Workbook. From there, various other methods are called, and finally, the CloseExcelDoc() is called when finished.

Methods I have added so far:

• filename() - returns the filename of the Excel document
• AddWorksheet(Optional strSheetName) - adds a worksheet. If strSheetName is omitted, then the default sheet name is used.
• Private Sub ErrorMessages(intErrNum) - class-wide error capturing
• FindSheet(SheetName) - searches the application for a given sheet

Although UBI has already produced an Avatar game, they missed the mark by not making it an MMO. I have no intention of even buying the game unless it is a persistent multiplayer online world. I grew bored with first-person shooters and player vs computer strategy games a long time ago. MMOs are the only games I play now and face it, they are the wave of future gaming.

Avatar would make a really great MMO. I bet that it could even give WOW a run for it’s money. As the game is now, I predict that it might gain popularity for a brief time because of the movie’s success, but it will fade fast. An MMO on the other hand, I predict, would have real and lasting popularity.

If you feel the same way as I do, go to http://avatargame.us.ubi.com/#/dashboard, log in (or make an account), and post it on their forums. There is a thread already for this at http://forums.ubi.com/eve/forums/a/tpc/f/6391049957/m/7421042628. If enough people show an interest, maybe UBI will come up to the 21st century and make a truly modern game of Avatar; a MMO!

Saw Avatar last night at the Cobb theater in Westly Chapel, Fl. What an awesome movie!! What an awesome theater to see it in!!

The theater had a balcony with large, comfortable chairs. We where served a meal and drinks at our seats. The lobby was magnificent and the staff was very friendly and helpful. Theaters really need to step it up a notch to compete with other media, and this one, in my opinion, has done just that. I highly recommend going there, not just to see a movie, but to experience it.

Now for the movie. It’s really beyond words. It’s 3 hours an 14 minutes long, but seemed much shorter. The integration between what was filmed and the special effects was seamless. The story was captivating and the scenes breathtakingly beautiful. It was tempered with the right amount of action, drama, and love scenes. You don’t have to be a fan of scifi to really enjoy this movie.

I’ve heard the following argument from IT: “What happens if you leave?” That is, suppose I leave for another job or something happens to me and I’m not available to perform my duties as an IT person in Material Planning.

Here’s a solution:

I am a leased employee from Volt. Therefore, department O57 is paying Volt an hourly fee for my services. Why couldn’t Northrop Grumman IT provide the same services to the department? O57 would be paying the same as they are presently, and IT, just like Volt could make a tidy little profit as well.

Sounds like a win/win situation to me.

If you interested in joining Free Masonry, search “Grand Lodge of <insert your state here>”. Although I haven’t checked all states, I’m pretty sure that each has a Grand Lodge website where information about membership can be found. Here in Virginia, the URL is http://www.grandlodgeofvirginia.org/membership/index.htm

The basic requirements are that you must be a man, 18 years or older, have no felonies, must not be an atheist, and must believe in one all mighty being.