Use this bit of VBA to create a list of Excel sheet name. - EASY Just add this code in VBA to the ThisWorkbook node and press F5 Sub ListSheetNamesInNewWorkbook() Dim objNewWorkbook As...
Category: VBA
Here's a function that will close all object in MS Access using VBA Function closeAll() Dim aob As AccessObject With CurrentData ' "Tables" For Each aob In .AllTables If aob.IsLoaded...
I have many databases that contain code to create a GUID that I use for renaming and importing files. Microsoft just put out a security update that blocked Scriptlet.TypeLib from being accessed. ...
If you're running ADODB to run a stored procedure on say SQL Server. It's helpful to know if the parameters you're expecting to be passed actually are. Add the For Each code block below just...
This took a while to figure out but Art Polk came to the rescue. I had a popup form that when a button was pressed I needed to update the subform of the form which created the popup I was currently...