Emerson Exchange 365

• Not Answered

Auto printing Daily report

Hi

I use Excel add -in and create report file but I need to print the report automaticly in special time , How can I do It?

Thanks & regards

 

• reporting

Jim Cahill

• 13 Dec 2011 2:01 AM
• Cancel

4 Replies

• Alfred Pol

  

  • 13 Dec 2011 9:48 AM

  It is possible with Microsoft Task Scheduler and an Excel Macro.

  • Cancel
• Jim Cahill

  

  • 13 Dec 2011 10:06 AM

  In reply to Alfred Pol:

  do you excel macro template?

  • Cancel
• Chris

  

  • 21 Dec 2011 12:32 PM

  Another possible solution I have used before (with DeltaV Reporter) is to use a Visual Basic Script and run it using Windows task scheduler.  The VBS can open an instance of Excel and print it out.  Example below:

  filename='Report.xls"

  set oExcel = CREATEOBJECT("Excel.Application") 'open an instance of Excel

  oExcel.visible = true 'show the instance, so we know what is going on

  oExcel.Workbooks.Open(filename) ' Opens the Excel Workbook

  oExcel.ActiveWorkbook.Worksheets.PrintOut 'Print current Workbook to default printer

  oExcel.Quit ' Exit Excel Workbook

  set oExcel = Nothing

  • Cancel
• Jim Cahill

  

  • 22 Dec 2011 7:04 PM

  In reply to Chris:

  thanks

  • Cancel