Welcome to my VBA Wiki

About This Site

My initial VBA code site, Code || VBA, DotNet, SQL, while useful for sharing code, makes updating awkward, in that I need to then work with my back-end MySQL server to make changes, rather than easier updates ala wiki.

About Me

My current resume (MS Word or LinkedIn Profile) is focused on VBA for both Excel and Access, within the financial technology environment, and I have programmed for a coterie of large investment banks and corporations on a variety of issues:

  • Market/IT Risk @ UBS
  • Trading Risk Management @ Deutsche Bank
  • Billing / Data quality @ NCR
  • Forensic accounting @ Deloitte
  • Server delivery cost reporting @ UBS
  • Business continuity planning @ Credit Suisse
  • Compensation review @ AIG
  • MS Office conversion @ ABN AMRO
  • IT management @ JP Morgan Chase
  • Project analysis @ Deutsche Bank

Other Sites of Mine

I also maintain a PHP-based website for Access and Excel VBA code, a newer site based and focused on .NET using ASP.NET and VB.NET, CodeDotNet. Besides day-to-day work and reading for technical development, I am documenting learning F# via Project Euler, as well as creating example design patterns and example algorithms.

Recent Updates

A code module for working with document properties, and aoption often better than using hidden...
(by James Igoe 18 Feb 2011 14:48, posts: 1)
http://vba.wikidot.com/ModifyFiles
(by James Igoe 19 Nov 2009 11:19, posts: 1)
http://vba.wikidot.com/logging
(by James Igoe 26 Sep 2009 14:36, posts: 1)
Data Object
(by James Igoe 10 Feb 2009 11:42, posts: 1)
Count Business Days (SQL)
(by James Igoe 30 Sep 2008 11:34, posts: 1)
Query Windows Domain (Access MDB)
(by James Igoe 09 Aug 2008 12:47, posts: 1)
Zip Class
(by James Igoe 24 Jun 2008 20:54, posts: 1)

See All Recent Updates

Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License