This should be simple for someone out there: I want to provide a file chooser dialog box for users to determine the path for a group of Excel files I'm exporting from my database using the TransferSpreadsheet command (I want them to be separate worksheets in one workbook). For one file, I know I could use "MicrosoftExcelBiff8(*.xls)" as the file name in the TransferSpreadsheet statement, but I can't figure out how to save that file info to use for transfer of the subsequent queries/spreadsheets. I found an example in the Help menu on how to display a file chooser window & save the path, but the first line in the example, "dim fd as FileDialog", stops the compiler with an error that says "Compile Error: user-defined type not defined". I'm betting I have to add a reference to use the FileDialog data type, but I'm not sure which one - can anyone help me with this? thanks!
I've already got that one! The references I have checked are (in order): Visual Basic for Applications, Microsoft Access 11.0 Object Library, OLE Automation, Microsoft DAO 3.6 Object Library, Microsoft ActiveX Data Objects 2.1 Library, and Microsoft Calendar Control 11.0.