This lesson comes as part of a series on building Microsoft Access Applications So this one was tricky, and it… Read more MS Access Application: VBA ‘Save-As’ Dialog to Save Entire Application in a New Location
MS Access Application: How can I use VBA to check if a table already exists?
This lesson comes as part of a series on building Microsoft Access Applications There may come a time where you’re… Read more MS Access Application: How can I use VBA to check if a table already exists?
How can I set up Excel to check if the computer is connected to the internet?
This is an AWESOME question! Sometimes when you design your excel application, you need it to be connected to the… Read more How can I set up Excel to check if the computer is connected to the internet?
How can I improve the performance of my VBA code?
Procedures that Help Performance of your VBA The below sub procedures will help your VBA run more efficiently. There are two… Read more How can I improve the performance of my VBA code?
How do I use Excel to search for files on my computer?
Great Question! This one is a tough one and it took me quite bit of time to get right. I… Read more How do I use Excel to search for files on my computer?
How Do I Control SAP from Excel?
Good Question! You can control SAP from Excel by using the below script in any Excel Workbook. This script took… Read more How Do I Control SAP from Excel?
