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 […]