How change cell format in excel using VBA in MS access

[Ronald_yoh]

Hi there,

i'm trying to change cell format in excel as "text" from MS Access (VBA).

how do i achive this?

i tried the following code in MS Access but no luck (does not change the format):


Set oExcelApp = New Excel.Application
oExcelApp.Workbooks.Open ("C:\book1.xls")
oExcelApp.Visible = True
oExcelApp.Sheets(1).Activate
oExcelApp.Sheets(1).Cells.Select

With oExcelApp.ActiveCell
.NumberFormat = "@"
End With

oExcelApp.ActiveWorkbook.Save
oExcelApp.Quit


thanks
R

[OBP]

Are you trying to change it FROM Text?
Or TO text?

[CreganTur]

Depending on what yuo're doing, you might have to change the formatting on your spreadsheet and then re-enter your data to get it to correctly conform to the format you've declared.

[Ronald_yoh]

Hi all,

thanks for replying..

anyway, i've solved the issue!

thanks again!