K KristenD Registered User. Local time Today, 14:32 Joined Apr 2, 2012 Messages 394 May 24, 2013 #1 I am combining forms and queries to make my DB more user friendly. Everything was working on the forms until I tried the export button. How do figure out what is going wonky on this code? Thanks! Kristen Attachments ExporttoExcel.JPG 31.2 KB · Views: 143
I am combining forms and queries to make my DB more user friendly. Everything was working on the forms until I tried the export button. How do figure out what is going wonky on this code? Thanks! Kristen
C CJ_London Super Moderator Staff member Local time Today, 19:32 Joined Feb 19, 2013 Messages 17,755 May 25, 2013 #2 have you tried acSpreadsheetTypeExcel12 rahter than acSpreadsheetTypeExcel12xml?
C CJ_London Super Moderator Staff member Local time Today, 19:32 Joined Feb 19, 2013 Messages 17,755 May 25, 2013 #3 Also, do you have the folder path correct, no typo's. If you are in a corporate setup, it may be your desktop is actually on your network
Also, do you have the folder path correct, no typo's. If you are in a corporate setup, it may be your desktop is actually on your network
