Spreadsheet Control in VBA Form

[promod33]

Hi,

I am using a spreadsheet control in VBA form with following connection string :

Const stCon As String = "Provider=Microsoft.Jet.OLEDB.4.0;" & _

"Data Source= c:\Data.xls;" & _

"Extended Properties='Excel 8.0;HDR=Yes'"


All is fine and data gets displayed correctly. However,I observed that original formatting ( like bold,font size etc. ) is lost. Any help ?

Thanks in advance.