EXcel spreadsheet from VB

Hi
I have the following problem :
I have embedded a exel ole object in one of my forms.
Now within my program I turn it into a Ole Automation object.
eg. dim exelobj as object
set exelobj as OLE1.object
I then populate the neccessary cells.

all works fine up to this point.

I then try to save the exel sheet using the following command exelobj.worksheets(1).saveas "test.xls". It creates the exel file but the file is blank.

please help:confused:

I don't know what your problem is, but there is a simple excel tutorial project at the link below my name and it successfully does what you are trying to do, so check it out.