Convert Excel to PDF with WinRS execution of remote host scripts

You need to convert the Excel file in the file server to PDF, investigate for many days, and now record the main steps.

1. Script Excel to convert PDF through VBScript and put it into the file server.

Script Code Reference:

Http://www.thoughtasylum.com/blog/2012/12/20/vbscript-to-convert-microsoft-office-files-word-excel-powerp.html

2. File Server Installation Office, note if the system is 64-bit, be sure to install 64-bit Office, otherwise the remote call script will always prompt that the Excel file cannot be accessed

3. Start the WinRM service on the file server and start the script remotely via the WINRS command on the client

WinRM Boot Reference:

https://msdn.microsoft.com/ja-jp/library/windows/desktop/aa384372 (v=vs.85). aspx

4. Open remote startup settings for Excel in the file server

Open Control Panel, Administrative tools, Component Services, locate Microsoft Excel application in the DCOM composition, open its Properties window, tick the interactive user in the ID category, click Save

5. When the client accesses the file server through the WinRS command, start the conversion script

such as: winrs-r:196.168.3.6 cscript d:/converttool.vbs E:/excel.xls

Convert Excel to PDF with WinRS execution of remote host scripts