Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Printing an Excel Spreadsheet
Message
 
To
30/01/2001 17:02:16
Jim Rieck
Quicken Loans/Rock Financial/Title Sourc
Livonia, Michigan, United States
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00470367
Message ID:
00470442
Views:
32
Try
oExcel.ActiveWindow.SelectedSheets.PrintOut()

>>>>>>>>Your mesage below
Hey All,

Does anyone know how to make Excel print a spreadsheet after it's open from VFP using OLE automation? Existing code is below, thanks for the help.

Jim

oExcel=CREATEOBJECT("Excel.Application")
oExcel.Workbooks.Open(SYS(5) + SYS(2003) +"\docs\compat.xls")
oExcel.Visible=.T.
Previous
Reply
Map
View

Click here to load this message in the networking platform