Code Updates
Forum » What's New / Code Updates
Number of threads: 15
Number of posts: 15
rss icon RSS: New threads | New posts
Running commentary on code and page updates
Order by:
Last post date
Thread starting date
Create a new thread
Thread name Started Posts Recent post
A variety of code additions
by: James IgoeJames Igoe
18 Feb 2011 14:48
1  
A class for modifying Excel workbooks, focused on OLAP pivot tables and code modifications.
by: James IgoeJames Igoe
19 Nov 2009 11:19
1  
A basic class for logging to text files in Excel
by: James IgoeJames Igoe
26 Sep 2009 14:36
1  
A class module for Excel or Access, that encapsulates a specific implementation SQL Server data, although most properties are constants within the class, to separate the data interaction from the application. As or methods, it has numerous public methods for invoking stored procedures to retrieve, add, delete, and update records, filtering the recordset, and private methods for establishing/closing connections, verifying user access, verifying version.
by: James IgoeJames Igoe
10 Feb 2009 11:42
1  
Working with Access, I needed to calculate business days between dates, excluding holidays, and with an eventual conversion fo the DB to SQL Server, rewrote the VBA into an SQL function.
by: James IgoeJames Igoe
30 Sep 2008 11:34
1  
Updated an Access DB that queries the domain for objects, e.g., user ID's, along with the related account fields by adding the ability to collect group membership (ACL's) or each account. Additionally, added a form/process that enables querying the domain for single accounts.
by: James IgoeJames Igoe
09 Aug 2008 12:47
1  
Access class module that automates zipping files, with parameters.
by: James IgoeJames Igoe
24 Jun 2008 20:54
1  
Saves toolbar positions in an excel file, allowing a user to restore the toolbar layout at a later date.
by: James IgoeJames Igoe
08 Jun 2008 12:22
1  
Added the ability of send the current workbook via Notes or Outlook. Somewhat rudimentary, although it can try and verify names in the address book, and the Outlook piece has not been tested, but easy enough for someone else to build on.
by: James IgoeJames Igoe
25 Apr 2008 17:18
1  
Class for workdate, and function for count of workdays between days
by: James IgoeJames Igoe
20 Apr 2008 13:21
1  
Function to check the Excel version, 97 to 2007, returning a text string
by: James IgoeJames Igoe
16 Apr 2008 18:50
1  
Toolbar fro many commonly used functions, as well as automated print formatting
by: James IgoeJames Igoe
16 Apr 2008 18:22
1  
by: James IgoeJames Igoe
15 Apr 2008 11:30
1  
by: James IgoeJames Igoe
15 Apr 2008 11:28
1  
by: James IgoeJames Igoe
14 Apr 2008 19:13
1  
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License