-
I want to expor data like data in a msflexgrid or listview to a excel file, from a VB proyect
But i want to change the colums properties, and put formulas or totals.
I don't know and i can't find, for example, to change the backcolor of a cell.
Another thing, when i fill the cell with some text like this
xlsApp.Cells(15, 2) = "=SUM(B2,B10)",
when i open the file in excel, the cell appears with "#######".
-
#####
That means the cell is not wide enough...
just adjust the cell width
as far as settings...
create a macro in excel...and then check the code...
usually you can change it for VB