Showing posts with label Automation. Show all posts
Showing posts with label Automation. Show all posts

Friday, January 3, 2014

Automating OpenOffice applications - CodeProject

Who need Microsoft Office?! I did not know it was possible to automate OpenOffice, but here is an article about how to do it.

Automating OpenOffice applications - CodeProject

Sunday, January 15, 2012

Home Automation with Netduino and Kinect - CodeProject®

Introduction to article


Home automation has been an interest of mine for a long time. There is a bunch of bad technology in the marketplace and the products are too expensive so I decided to build my own. I started out with the Arduino microcontroller which was really fun but the code quickly became hard to maintain because it was not object oriented. Additionally it could not do multithreading or real debugging with breakpoints and such. I refactored the code for C# and the .NET Micro Framework. I choose the netduino plus, http://www.netduino.com/netduinoplus/specs.htm, for the microcontroller which has a built in Ethernet adapter for network communication.


Home Automation with Netduino and Kinect - CodeProject®
Enhanced by Zemanta

Tuesday, May 3, 2011

Tutorial : Advanced Silverlight Out of Browser- Introduction - The Official Microsoft Silverlight Site

Silverlight LogoImage via WikipediaOverview:

Silverlight out-of-browser enables you to create desktop applications. Using elevated trust further opens the possibilities of what your application can do. This lab is designed to further explore what can be down with an out-of-browser Silverlight application.
In the lab you'll create an application that imports data directly from Excel. Along the way you'll learn how to interact with the hard drive, check for updates, and work with Excel from Silverlight.

You'll start by dragging and dropping Excel files onto the application. Next, you’ll call Excel through the AutomationFactory and process the data. You’ll create files and directories on the hard drive to store temporary data. Finally, you’ll learn how to check for application updates. The Silverlight application that you'll create is shown next:



Tutorial : Advanced Silverlight Out of Browser- Introduction - The Official Microsoft Silverlight Site
Enhanced by Zemanta

Wednesday, February 23, 2011

Remote Desktop Control with Automated Skype - CodeProject

Purpose of article

Skype automation allows a user to control desktop of another user with built-in screen sharing.

Remote Desktop Control with Automated Skype - CodeProject
Enhanced by Zemanta

Monday, July 20, 2009

Automating Excel from VB.Net - Link to Excel Lost


I've been maintaining some software of years that i wrote that compares inventory data with GIS data. It uses some of Excel's spreadsheet function to pull this off. I use Excel's object library to get the effect. It's worked great until recently and ironically the problem shows up most consistently on the fastest computer I've ever used at work up until now. In the middle of processing, I've been getting an error message that says that the "link to the spreadsheet has been lost" and then the program crashes. For days I could not find the problem. But then when I stepped through through the VB.Net code stey-by-step the program worked then I realized it was because I allowing the steps in Excel to finish before the rest tof the program continued. It turns out that because my program and Excel are being processed in different threads, the Excel thread could be lagging behind my code. I have had to put code into a function in VB that tells the processor to pause for a certain number of milliseconds. 1000 milliseconds is 1 second. Therefore

System.Threading.Thread.Sleep(10000)


makes the program pause for 10 seconds which would give the excel thread 10 more seconds to complete what it is doing. It's my theory.