Excel format "Text to column" using ACCESS VBA

[msaccessdev]

Hi there,

I am trying the change the excel cell value format to number from general after exporting data from access query record set to excel. but the format is not changing and causing me problem of not updating the formulas in the excel file.

i tried the "eWS.Application.Range("L10:L" & rowcnt).NumberFormat = "_(* #,##0_);_(* (#,##0);_(* " - "??_);_(@_)"" this option but nothing is working here.

i tried to change the format directly in the excel and exporting the data form access ... but the format is getting changed since the export is done.

please help.

[ItsMe]

I have never tried using the NumberFormat property from Access.

Have you tried, first, to set the type by using
...NumberFormat = "Number"

and then find a way to limit the number of decimals. And then manage how the commas, etc. are displayed???
...NumberFormat = "_(* #,##0_);_(* (#,##0);_(* " - "??_);_(@_)"

[msaccessdev]

yeah, I tried almost all the possibilities. like

NumberFormat = "General"
NumberFormat = "Accounting"
NumberFormat = "Number"
NumberFormat = "$#,##0.00"
NumberFormat = "#,##0.00"

and nothing seems working. If i do it manually in the Excel file through the option of "TextToColumn" Delimit ... the format is changing. but if i do the same way through MS Access code ... its not updating.

thanks

[ItsMe]

Perhaps posting the code you are using will shed some light. One thing to keep in mind is that VBA for Access is not VBA for Excel. Methods and properties available in Excel may not be available in Access and vise versa.