Specifying number of decimals when exporting data

[Yobi4ever]

Hi,
I use the built in tools "Analyze data with excel to export" to export data from froms to excel and it works fine. The only problem is in the form and table I had specified 3 decimals but in excel the data is two decimals and I have to always reformat the cells manually to 3 decimals.

Any way to have this set when exporting even if I have to use VBA code.

Thank you.

 

[DCrake]

Simple Software Solutions

Hi

There is an alternative approach to what you attempting and that is to append the results of the recordset to a pre-existing Excel spreadsheet wih the column(s) in question already formatted to 3 decimal places.

Another advantage of this is that you can stipulate which cell to start the copy from, thus enabling you set up nice heading for your columns.

You will need to perform this in VBA on a command button on your form.

There is a very good aticle on the MS Kb (247412) which decribes several way of transferring data to Excel in VB(A).

Have a good programming day.
Code Master

 

[Yobi4ever]

Thank you DCrake... I will give this a look.