Information générale
Catégorie:
COM/DCOM et OLE Automation
Titre:
I want to email oSheet
Hi all,
I am doing some stuff like
oExcel = createobject("excel.application")
oWorkB = oExcel.workbooks.open(fname)
oWorkS1 = Workbooks.worksheet[1]
then I do row & cell manipulation
.value = "whatever"
Then at the bottom (of a do while) I Add a sheet
oWorkS1 = oWorkB.Worksheets.Add( ,oWorks1)
*At the bottom of my do while, What I would really like to do is somehow save the sheet I just created as an XLS
or otherwise pass the sheet as a ".XLS" so that my email process can attach it to outgoing email *
Is this possible? Thanks
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