TransferSpreadsheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all

I have used TransferSpreadsheet in VBA to export data from a query to Excel.
The cells are formatted to two decimal places with format([field],"fixed")
but Excel treats the data as text and therefore the alignment is incorrect.
Is there a way to make the data numeric so it lines up via the decimal point
without having to amend the spreadsheet manually after creation?

Thanks in advance for any help.
Sue
 
For reference, it works if I do Tools, Analyse with Excel - formatting is
retained but I wanted to do it via transferspreadsheet so I can specify the
location and filename to save it to. The filename includes a dealer code
relevant to the current dealer at the time the report is run.

Thanks in advance for any help.
Sue
 

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

Question Regarding TransferSpreadsheet w/ Formats 3
Transferspreadsheet - insert rows with no header 1
Export to Excel 3
passing params to multiple querydefs and transferspreadsheet 8
Export: use SendObject or Transfer? 2
export crosstab query too many fields error 1
export to excel and save 4
Access stripping decimal places in query 1

Back
Top