Control Apostrophe exporting to Excell 2010 from Access runtime 2010

hetfool

hetfool

Joined
Jul 2, 2012
Messages
1
Reaction score
0
I use the following command:

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, strQryName, strFileName

When I export from the full version of Access 2010 the export contains the control apostrophe (i.e. '01234 )

When I export from the RUNTIME version of Access 2010 the export DOES NOT contains the control apostrophe (i.e. 01234 )

I need it to contain that control apostrophe, any ideas?

For help, our access application is compiled in Access 2003 with references to Excell 14.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Migrating from 2010 to 2013 - having issues: Exporting to xml 0
Upgrading from Office 2010 to Office 365 1
Migrating app from 2003 to 2010 0
Active X Control in Access 2010 4
Access 2003 versus Access 2007 Excel Import 0
Access 2010 Runtime Silent Install 2
Help exporting URL format to Excel from Access Query 1
Opening Excel Workbook from Access after TransferSpreadsheet 2

Top