Hi everyone,
I have had a Dutch article on XML and Excel on my site for quite some time now, but never got round to translating the thing into English.
Well, yesterday I found a bit of time during a long train-ride, so here it is:
XML And Excel
From the intro:
Microsoft Office 2003 Professional was the...
As I mentioned earlier, I want to develop a framework generating app to create some of the code necessary to read and write to and from an Access database. This is iteration 1 of about 100.
Start with this table in Access
Set a reference (Tools - References) to Microsoft ActiveX Data Objects 2.8 Library...
Here's some code I have to generate a SQL statement Public Function BuildRepSQL(ByRef clsRepLine As CRepLine, eType As aiDBStatus) As String
Dim sReturn As String
With clsRepLine
Select Case eType
...
On of the most visited parts of my web site is the part on external data. Most of it was based on Excel 2003 and before, so I thought I should update it for Excel 2007. INTRODUCTION The first thing you will notice about 2007 is the ease in which you can find the data 'movement' tools. Now, say...
Elton is trying to create a QueryTable based on a named range in a closed Excel file. When the code tries to refresh the QueryTable object, he gets an SQL Syntax Error message. Although he's sure his SQL syntax is correct, it's almost certainly not. The syntax you get from the macro [...]