Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Exporting with docmd.transferspreadsheet yields corrupt workbook
1 view
Skip to first unread message
Muscat...@gmail.com
Sep 27, 2007, 7:21:51 PM9/27/07
to
I've run into this problem numerous times, using office 2000. I'd like
to export 5 queries to different worksheets in an excel file. I've
been using the "docmd.transferspreadsheet" command but when I export
even just one query, I can't open the workbook as it errors out. One
of my coworkers said he's heard of this problem before, so I'm
assuming others have too.
Anyone have a fix for this? I searched but can't find a thing, not
even in the groups. I'd like to stay away from writing a recordset
because it's much more labor intensive for me and there is only one
other person who has any experience with VBA in the office, so
troubleshooting would be difficult.
to export 5 queries to different worksheets in an excel file. I've
been using the "docmd.transferspreadsheet" command but when I export
even just one query, I can't open the workbook as it errors out. One
of my coworkers said he's heard of this problem before, so I'm
assuming others have too.
Anyone have a fix for this? I searched but can't find a thing, not
even in the groups. I'd like to stay away from writing a recordset
because it's much more labor intensive for me and there is only one
other person who has any experience with VBA in the office, so
troubleshooting would be difficult.
0 new messages