Check this out for the whole Excel Object Model
http://msdn2.microsoft.com/en-us/library/syyd7czh.aspx
I also used the Foxpro IDE to investigate the model in real time.
oExcel = createobject("excel.application")
then type oExcel. <-- and intellisense does the rest.
Some examples:
oExcel.activeworkbook.save()
oExcel.activeworkbook.saveas(<path/outfile>)
oExcel.visible = .t. <--- will open the
spreadsheet in an excel window
oExcel.workbooks.open("<path.filename>")
oExcel.printout() <--- Print out current sheet
oExcel.Range("H4").Value <--- return value from cell
oExcel.quit()
Etc., etc.
Good luck...
Lew wrote:
Thanks, Chet. Would you happen to know if there's a help file/chm around
somewhere that document the excel
object model?
-Lew
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Chet Gardiner
Sent: Tuesday, October 03, 2006 6:03 PM
To: [email protected]
Subject: Re: Which Excel pem to make an active worksheet?
oExcel.ActiveWorkbook.Sheets(<sheet number>).Select()
Lew Schwartz wrote:
Given an Excel automation object and a xls with several included work
sheets, what method and/or property do I use to make a named work sheet
the active worksheet so I can manipulate it?
TIA
-Lew
[excessive quoting removed by server]
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
