transferspreadsheet to export query to excel 07 as .xlsm

J

jmccullough

Registered User.
Local time
Today, 10:54
Joined
Jul 30, 2007
Messages
24
I am trying to use the transferspreadsheet to export Access 07 query to Excel 07 with file extension of xlsm. I am receiving a runtime error 3027. It works fine if I use file extension of xlsx but I need the workbook macro enabled.

Any thoughts or suggestions?
 
You must log in or register to reply here.

Similar threads

M
Export 2 forms to same spreadsheet
Replies
7
Views
917
mounty76
M
R
Access not 'receiving' command line passed to it in batch file
Replies
6
Views
488
The_Doc_Man
The_Doc_Man
C
Error 3828 when exporting queries to Excel
2
Replies
34
Views
2,037
ChrisMore
C
B
  • Question Question
export and transpose problem
Replies
6
Views
1,198
Gasman
Gasman
amorosik
Program1 works fine, program2 doesn't, due to a date problem, but code inside are the same
Replies
17
Views
1,430
gemma-the-husky
gemma-the-husky

Users who are viewing this thread

Total: 1 (members: 0, guests: 1)
Back
Top Bottom