![Anything Access](http://anythingaccess.com/wp-content/uploads/2024/05/section-03.jpg)
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
![Anything Access](http://anythingaccess.com/wp-content/uploads/2024/05/section-03.jpg)
Editing a NK2 files
This is so random that I had to include this here Every time that you type an email address or...
![Anything Access](http://anythingaccess.com/wp-content/uploads/2024/05/section-03.jpg)
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...
![Anything Access](http://anythingaccess.com/wp-content/uploads/2024/05/section-03.jpg)
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...
![Anything Access](http://anythingaccess.com/wp-content/uploads/2024/05/section-03.jpg)
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...
![Anything Access](http://anythingaccess.com/wp-content/uploads/2024/05/section-03.jpg)
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...
![Anything Access](http://anythingaccess.com/wp-content/uploads/2024/05/section-03.jpg)
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...
![Anything Access](http://anythingaccess.com/wp-content/uploads/2024/05/section-03.jpg)
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...
![Anything Access](http://anythingaccess.com/wp-content/uploads/2024/05/section-03.jpg)
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...
![Anything Access](http://anythingaccess.com/wp-content/uploads/2024/05/section-03.jpg)
Altova Mapforce
I am currently running a demo of the mapforce to review how the software works and how to implement the...