Hi Yuri,

I was able to

* Create a Template in Excel ( With all needed formatting )
* Copy Template to user selected excel file ( “Newpart.xls”)

That works fine. Now I need to open this empty “Newpart.xls” and insert data from dbf table (NewPart.dbf)

This is what I did

oExcel = CREATEOBJECT("Excel.Application")

oExcel.Workbooks.Open( “Newpart.xls”)

I just don’t know how to insert the data from NewPart.dbf ( open in current work area) to ( “Newpart.xls”) using DataToClip method. Also when I insert the data I want to start inserting from the 2nd row because first row has the formatted headings. Can you please direct me here ..

I tried everything but ended up with error messages.

Please Help !!

TIA.

- Jeana -