Naming an Excel workbook and worksheets 2

[chandler]

I've been looking for a way to name the workbooks and worksheets I create using VFP 9.0 So far I've found ways to create and select, but not to name. Any help is much appreciated.



Chandler
I ran over my dogma with karma!

 

[mm0000]

You try the following code

oExcel = CREATEOBJECT("Excel.application")
oWorkBook = oExcel.Workbooks.Add()
oWorkbook.Sheets.Add

osheet=oexcel.ActiveSheet
osheet.Name='My sheet Name'
osheet.SaveAs('c:\Mydirectory\MyfileName',43) &&Save in Excel 97 format
oexcel.Visible=.t.

 

[chandler]

Worked like a charm. Muchas Gracias.

Chandler
I ran over my dogma with karma!