topic Re: Coverting rtf to pdf using VBS code in linux server in Administration and Deployment

Coverting rtf to pdf using VBS code in linux server

mazz — Fri, 24 Mar 2023 12:48:26 GMT

bRecursive = False
sFolder = "D:\Users\gci0mxm\Desktop\Test"
Set oFSO = CreateObject("Scripting.FileSystemObject")
Set oWord = CreateObject("Word.Application")
oWord.Visible = True

Set oFolder = oFSO.GetFolder(sFolder)
ConvertFolder(oFolder)
oWord.Quit

Sub ConvertFolder(oFldr)
For Each oFile In oFldr.Files
If LCase(oFSO.GetExtensionName(oFile.Name)) = "rtf" Then
Set oDoc = oWord.Documents.Open(oFile.path)
Str = left(oFile,instr(1,oFile,".")-1)
oWord.ActiveDocument.SaveAs Str & ".pdf", 17
oDoc.Close
End If
Next

If bRecursive Then
For Each oSubfolder In oFldr.Subfolders
ConvertFolder oSubfolder
Next
End If
End Sub

I have created vbs file in linux server but I can't able to run inside the linux server.

Can you help me to run vbs file in linux server or any other alternate solutions for generating pdf from rtf in SAS (HMS/cloud).

Re: Coverting rtf to pdf using VBS code in linux server

Kurt_Bremser — Fri, 24 Mar 2023 19:29:26 GMT

You need a VB runtime executable on Linux. Your admins for the SAS server can help you in this regard. And you must be able to run external commands (SAS system option XCMD set), for which you also need your SAS admins.

Re: Coverting rtf to pdf using VBS code in linux server

Kurt_Bremser — Fri, 24 Mar 2023 19:33:52 GMT

But this

Word.Documents.Open

makes me suspect that you actually use Word for the conversion. Word is only available on Windows.

LibreOffice is available on Linux and can do such conversions from the commandline, IIRC.

Re: Coverting rtf to pdf using VBS code in linux server

Reeza — Fri, 24 Mar 2023 19:34:06 GMT

If you don't have permissions you may be able to add ODS PDF statements depending on the code used to have a PDF generated instead of RTF.

VBS typically doesn't run on Linux, usually a different approach is used.

Re: Coverting rtf to pdf using VBS code in linux server

Kurt_Bremser — Fri, 24 Mar 2023 19:40:34 GMT

And if the rtf is actually created with SAS, you only need to add ODS PDF to open the pdf destination.

Re: Coverting rtf to pdf using VBS code in linux server

Sajid01 — Mon, 27 Mar 2023 15:24:26 GMT

vbs does not run in the Linux environment.
If your objective is to convert rtf to pdf in a Linux environment there are command line utilities available to do the job. Speak to the Linux team for assistance.

Re: Coverting rtf to pdf using VBS code in linux server

SimonDawson — Thu, 30 Mar 2023 10:20:19 GMT

This is not anything related to SAS Administration nor Deployments. The only thing roughly making this something interesting to SAS users in this community is your question is about doing something with data on a SAS hosted platform.

There is nothing built into any SAS product to do this. If the source of the RTF is SAS ODS, simply update the program to use a PDF destination in addition to RTF. If the rtf file is produced outside of SAS then your only chance would be to find a package supported by Red Hat that can accomplish this.

My quick search reveals there is a possibility for LibreOffice to have an ability to take an RTF files and convert it to a PDF. See the --convert-to argument in the LibreOffice documentation here.