Ryan McCormick

file dialog

SOLVED: Late Binding File Dialog in VBA Example

by 4 Comments

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 in VBA with file dialog post. The original FileDialog post referenced above shows an example … [Read more...] about SOLVED: Late Binding File Dialog in VBA Example

Save File With File Dialog In VBA | Access

by 2 Comments

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 … [Read more...] about Save File With File Dialog In VBA | Access

Select or Open a file in VBA with file dialog | Access VBA

by 32 Comments

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. UPDATE 05/22/2015: The function below contains an error handler and works well if your … [Read more...] about Select or Open a file in VBA with file dialog | Access VBA