I have been trying to figure out a solution to late binding the file dialog object for a long time. I have played with the code, googled for examples and haven’t had much luck until today when a generous visitor of ours posted the solution in the comments of our Select or Open a file […]
File Dialog
Save File With File Dialog In VBA | Access
A couple of years ago, I posted code for selecting a file with VBA. This example demonstrates how to use the file dialog to return a Save-As string. VBA File Dialog Save-As ‘————————————————– ‘ File Dialog Save-As ‘————————————————– ‘NOTE: To use this code, you must reference ‘The Microsoft Office 14.0 (or current version) ‘Object Library […]
Select or Open a file in VBA with file dialog | Access VBA
In a recent project, I was tasked with designing a program in Access where an end user could import a spreadsheet, run a sub routine in VBA and export the results. As part of the user experience, I wanted the end user to be able to select the input spreadsheet with the file dialog tool. […]