So you’ve created a magnificent automated report in Excel that just pulls the data in via XML and your customers go “wow!” when they see how easily your reports work, until….

Error: User-defined type not defined

Error: User-defined type not defined

This seams to be because a newer version of MSXML (v6.0 in this case) was installed. To get your document to work as expected again, you need to select the proper reference libraries for MSXML. In my case I needed to change it back to MSXML v3.0 to get it to work.

Continue reading

I cannot believe how simple this is, yet I had to google to figure it out (why oh why didn’t I just read the ‘man’ pages). The syntax for executing a remote command is as simple as:

## SYNTAX
ssh [user]@[remote host] [command]
 
## EXAMPLE
ssh techedemic@192.168.1.200 df -h
 
techedemic@192.168.1.200's password: 
Filesystem                             Size  Used Avail Use% Mounted on
/dev/mapper/td--VG1-td--LV2            443G   89G  332G  22% /
udev                                   993M  4.0K  993M   1% /dev
tmpfs                                  401M  628K  401M   1% /run
none                                   5.0M     0  5.0M   0% /run/lock
none                                  1002M     0 1002M   0% /run/shm
/dev/sda1                              241M   38M  191M  17% /boot