Macro TransferSpreadsheet

I

If

Hello,

I have a problem with this function (TransferSpreadsheet).

Transfer Type : Export
Type of Sheet : Microsoft Excel 8-10
.....

My problem is as follows:

The data exported to Excel are in format text.
I would like that the numerical data remains numerical data in Excel.

A small assistance?
 
K

Ken Snell [MVP]

You don't tell us anything about the actual data. Is it a mixture of numbers
and nonumbers? If yes, then you'll get the Text format; no way via
TransferSpreadsheet to change that.

Tell us more details.
 

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

cannot expand named range 1
Setting format in TransferSpreadsheet 1
Question about "TransferSpreadsheet" action 4
TransferSpreadsheet 4
Office 2007 TransferSpreadsheet Import 5
Export from MS Access 2007 to Quickbooks IIF - How can I create a tabdelimited text file from Access 2
transfer spreadsheet-create a date 2
Export to Excel 3

Top