5/22/2009

XML is case sensitive

Say it again three times...
XML is case sensitive
XML is case sen...
Anyway, I knew that . Well formed XML is case sensitive. I'm sending data to Excel, so what's wrong with my code:

<Workbook>
  <Worksheet>
    <table>
      <Row>
        <Cell>
        </Cell>
      </Row>
    </table>
  </Worksheet>
</Workbook>

All of the XML editors say it's perfectly fine XML but Excel doesn't like it. It seems to open the file but nothing displays. Remember, XML is case sensitive! Excel's XML tags are also case sensitive:

<Workbook>
  <Worksheet>
    <Table>
      <Row>
        <Cell>
        </Cell>
      </Row>
    </Table>
  </Worksheet>
</Workbook>

Thus, to open XML in Excel, the tags must be spelled exactly as above.
<table> with a lower case t won't do!!

Arrrrrrrrrrrrrrrgh!!

I changed out the motherboard in my computer but now I can't find a driver for the RealTek network card. It's a 64bit processor and I'm stumped! MSI keeps wanting me to run the auto updater, but that won't work without a connection to the internet! Duh!!

5/08/2009

VB - Tricky little error

I copied some code today for an Access 2007 project. Just couldn't get it to work. I finally looked very closely at the code. Do you see the difference between the two lines above? The top line works correctly. The bottom line does not.

The bottom line looks like the code that I copied. Notice the opposite facing quote marks. They don't work in Access 2007 VB. Go figure. Looks like the author of the post that I got this code from was writing his article with an MSWord editor and it "corrected" his code for him.

5/01/2009

Relay for Life at Rockledge High

The Relay for Life and Taste of Rockledge is tonight, Friday, May 1 at the Rockledge High track. There are usually lots of cookies, brownies and goodies. Come on out and walk around the track for a little exercise and eat some goodies!