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
Archives for February 2015
VBA Export to CSV From SQL With Save-As in Access
Although not as common as exporting to Excel, some projects may have a need to export in .csv format. Here is my solution. VBA Export With User Defined SQL Query This example uses the QueryDef function. Basically, the user passes a SQL query in, the file dialog prompts for where to save-as and the export is completed. 'To use file-dialog, you must add a reference 'to … [Read more...] about VBA Export to CSV From SQL With Save-As in Access