Browse by Tags

All Tags » VBA - Office (RSS)
Sorry, but there are no more tags available to filter with.
Tuesday, October 10, 2006 7:57 AM

Coding VBA with VBA.

The idea of writing code that writes code has a certain coolness about it. Being able to give your application the ability to recode itself is part and parcel to AI techniques of coding intelligence because essentially your application can grow and learn...
Posted by dsmyth
Filed under:
Friday, September 29, 2006 3:50 PM

Column letter to column number in Excel.

In a previous blog I posted a VBA algorithm for Excel that took the column letter (A, B, Z, AA) and returned the corresponding column number. There was a tiny little problem in the code, so I'm reposting the entry with the fix. The tiny little problem...
Posted by dsmyth
Filed under:
Saturday, September 09, 2006 11:41 AM

VBA Regular expressions with Word

Another post in VBA MSDN, it's been a slow week, asked 'is it possible to select all upper case words in a word document". I haven't done much programming with Word's API so thought I'd give it a shot as it gave me an excuse to...
Posted by dsmyth
Filed under:
Friday, September 08, 2006 9:12 AM

Accessing Excel workbook as database schema (ADOX).

Another question posted onto MSDN VBA asked the question, I want to retrieve (using ADO) Excel worksheet name and total count of sheets. Very straight to the point ! Well since I'd solved the other problem I wondered if this was possible and it is...
Posted by dsmyth | 1 comment(s)
Filed under:
Thursday, September 07, 2006 2:27 PM

Treating separate worksheets as relational data in Excel.

A request on the MSDN VBA forum got me thinking. The problem was this; in Excel there are two ADO recordsets, (a) and (b), populated from SQL Server both containing a different list of ID's. How do you find the items that appear in (a) but not (b...
Posted by dsmyth | 1 comment(s)
Filed under:
Wednesday, August 23, 2006 5:20 PM

Get MAC Address - Windows API

Here is a link to an article that contains Windows API code for getting the MAC address of the computer. I haven't tried the code out in VBA but it's a nice piece of code to keep. http://www.osix.net/modules/article/?id=2
Posted by dsmyth
Filed under: