Information générale
Catégorie:
COM/DCOM et OLE Automation
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 -
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement