Importing via macro - changes format

D

dcozzi

I import a table from excel with the use of the macro. When i save it in
excel, all the rows are formated as text. After import the table, the data
from roughly column E over, i in scientific notation. How do you select the
field characteristics when importing with a macro?
 

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

Change a great number of words in word files, with a macro as short as possible. 5
Table of content - format does not get saved 2
Cell data entering slow! 0
import excel data - scientific notation 1
Excel does not accept text format! 0
sqlite-odbc write conflict 2
Importing via TransferSpreadsheet, receiving "type conversion fail 1
Paste to excel from word - auto format problem 1

Top