I have a saved import and export, created using the wizard that allows me to save the backup information as an Excel 2007 file. I cannot, however, determine how to do this with VBA using the “docmd.TransferSpreadsheet”
I tried the following, but the resulting file cannot be opened...