Consolidate the contents of multiple excel sheets
This is a very useful macro to add the contents of several excel sheets onto a single sheet
Editing a NK2 files
This is so random that I had to include this here Every time that you type an email address or...
Checking the References in an Access Database
This code from the MS site checks the references and can fix broken references – the compile will only work...
Using Passthrough query in Access
We have recently converted a database from Access to SQL and needed to increase the speed of the reports when...
Preserving Excel Comments Across versions
You may need to save comment from one excel model and load them into another file. This can be a...
Auto Unzipping Files and Loading of Excel Files
We used this function to automatically unzip Excel files , the files had been sent by email and an outlook...
SAP – Changing the format of downloaded files
The SAP system often downloads files as MHT which can be opened in excel but can be enormous After getting...
Agresso Budget Loading from Excel
Actually this could be used for a variety of purposes but I wrote this for Agresso. This is designed for...
Loading Files from a Folder
I use this function to load CSV, txt and Excel files as part of the ETL Process. An example of...
Altova Mapforce
I am currently running a demo of the mapforce to review how the software works and how to implement the...