Industrial Automation
Industrial Automation | Europe

myKnowledge

Main > Product Type > Software > Visualisation
Minimize Text   Default    Enlarge Text
 

Print
E-mail

How Do I Get CX-Supervisor To Print Out An Excel Spreadsheet Using VBScript?


The following VBScript will print out the contents of a worksheet in Excel from CX-Supervisor:
 
' Launch Excel
dim app
set app = createobject("Excel.Application")
       
' Open workbook
dim wb
set wb = app.Workbooks.Open("D:\CX-SupervisorApps\mysheet.xls")
    
app.application.sheets(1).printout

'Close, quit and tidy up
app.Workbooks.Close
app.Quit
Set app =
Nothing




Comments (View All Comments / Add Comment)

Related Articles
No related articles found.
Created 2009-09-07
Modified 2009-09-07
Views 3945

 

You are not logged in.