Updates
|
2010-08-27
|
Exposing C# to VBA via COM
I recently toyed with creating a C# project that can be used to expose methods to VBA via COM automation. The project implements one form for printing, but otherwise has no UI. Included is a text file showing how to access and execute the methods via ....more |
|
2010-06-15
|
Deprecated Features of Excel 2010
I recently found out that a basic command, ENVIRON, used to get system variables no longer works in Excel 2010, prompting me to research all of the deprecated features in the upcoming release.
Two articles from the MSDN blog: ....more |
|
2010-05-14
|
Avoiding COM-Related Memory Leaks with Excel
Recently I was handed a combined WCF service and Excel 2007 add-in done in C#. project. Although most .NET developers assume garbage collection is handled automatically, it is definitely not true when working with COM objects assume ....more |
|
2010-05-07
|
To preserve pivot table compatibility, short of writing fairly complicated code, you need to use a 2003 file format, so you can work in both Excel 2007 (Version 12) and 2003 (Version 10). Below are quotes from an MSDN blog explaining why, as well as links to two (2) pages detailing related issues.
....more |
|
2010-05-07
|
Uploaded a distilled version of .NET naming conventions, simplifying standards for use. |
|
2010-05-07
|
Uploaded an updated list of design patterns covering ideas laid out by the GoF, Code Complete, Pattern-Oriented Software Architecture, and Patterns of Enterprise Application Architecture. | | read all... |
|
|
About This Site
Initially designed to share VBA code and resources, it has expanded to include work in SQL (T-SQL) and .NET (C#/VB.NET/ASP.NET).
About Me
My current resume (MS Word or Linked In Profile) is focused on VBA for both Excel and Access, as well as .NET and SQL, 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 Investment Bank
- Trade management @ Deutsche Bank
- Billing / Data quality @ NCR
- Forensic accounting @ Deloitte
- Server delivery cost reporting @ UBS
- BCP @ Credit Suisse
- Compensation review @ AIG
- MS Office conversions @ ABN AMRO
- IT management @ JP Morgan Chase
- Project analysis @ Deutsche Bank
Other Sites of Mine
I also maintain a wiki for Access and Excel VBA code, VBA @ WikiDot, a newer site based and focused on .NET using ASP.NET and VB.NET, CodeDotNet, along with this and other sites, two with dated professional work. One a site for Deutsche Bank Asset Management IT in New York, and the other a presentation of marketing recommendations for a software firm repositioning itself after the WTC tragedy.
|
