Solved

VBSCRIPT that opens a RTF file in word PRINT PREVIEW mode and saves it in another folder

Posted on 2013-01-25
3
788 Views
Last Modified: 2013-02-04
Hello EE,

I have several rtf files that were created using SAS.  The page numbers (Page x of y) "appear" to be missing but can be seen if opened in "Print Preview" or when the table is printed.  What I would like to do is run a vbscript that does the following:  1) opens the file in "Print Preview (CTRL+F2)" mode.  2) file "save as" the same file in another folder.  This saved file will now show  the page numbers.  I currently have about 100 files and I really don't want to do this to each one.  I am attaching the file as an example.  This script will then be used as the second step of the process to see the page number values.  

Thanks in advance for your help...

Jeff
LBI-PTRB3SCR-smdisd1-test.doc
0
Comment
Question by:ratliffjm
  • 2
3 Comments
 
LVL 35

Assisted Solution

by:Robert Schutt
Robert Schutt earned 500 total points
ID: 38825029
Try this:
Option Explicit

Const C_FOLDER_BASE = "C:\temp\"

Const C_FOLDER_INP = "input\"
Const C_FOLDER_OUT = "output\"

Const wdFormatDocument = 0

Dim oWrdApp, oWrdFil, oFS, oFolderInp, oFile, oFolderOut

Set oWrdApp = CreateObject("Word.Application")
oWrdApp.Visible = True

Set oFS = CreateObject("Scripting.FileSystemObject")
Set oFolderInp = oFS.GetFolder(C_FOLDER_BASE & C_FOLDER_INP)

For Each oFile In oFolderInp.Files
    If LCase(Right(oFile.Name, 4)) = ".rtf" Then
        Set oWrdFil = oWrdApp.Documents.Open(oFile.Path, False, False, False)
        oWrdFil.PrintPreview
        oWrdFil.SaveAs C_FOLDER_BASE & C_FOLDER_OUT & Left(oFile.Name, Len(oFile.Name) - 3) & "doc", wdFormatDocument, , , False
        oWrdFil.Close False
        Set oWrdFil = Nothing
    End If
Next

Set oFolderInp = Nothing
Set oFS = Nothing

oWrdApp.Quit
Set oWrdApp = Nothing

Open in new window

0
 

Author Comment

by:ratliffjm
ID: 38832197
I edited your code and I got the following error:

Script" S:\REFMAL197\pageit.vbs
Line:16
Char: 1
Error: Path not found
Code: 800A004C
Source: Microsoft VBScript runtime error

My edited code is below. I think I made a mistake with the C_FOLDER_BASE. What should be the path of this value?

Option Explicit

Const C_FOLDER_BASE = "S:\REFMAL197\Deliverable\TFL\Production\Output\output_test\"

Const C_FOLDER_INP = "S:\REFMAL197\Deliverable\TFL\Production\Output\output_test\"
Const C_FOLDER_OUT = "S:\REFMAL197\Deliverable\TFL\Production\Output\output_testit\"

Const wdFormatDocument = 0

Dim oWrdApp, oWrdFil, oFS, oFolderInp, oFile, oFolderOut

Set oWrdApp = CreateObject("Word.Application")
oWrdApp.Visible = True

Set oFS = CreateObject("Scripting.FileSystemObject")
Set oFolderInp = oFS.GetFolder(C_FOLDER_BASE & C_FOLDER_INP)

For Each oFile In oFolderInp.Files
    If LCase(Right(oFile.Name, 4)) = ".rtf" Then
        Set oWrdFil = oWrdApp.Documents.Open(oFile.Path, False, False, False)
        oWrdFil.PrintPreview
        oWrdFil.SaveAs C_FOLDER_BASE & C_FOLDER_OUT & Left(oFile.Name, Len(oFile.Name) - 3) & "doc", wdFormatDocument, , , False
        oWrdFil.Close False
        Set oWrdFil = Nothing
    End If
Next

Set oFolderInp = Nothing
Set oFS = Nothing

oWrdApp.Quit
Set oWrdApp = Nothing



Thanks  so much!!!

Jeff
0
 
LVL 35

Accepted Solution

by:
Robert Schutt earned 500 total points
ID: 38834244
The intentention was to use BASE as the base folder and input and output below it:
Const C_FOLDER_BASE = "S:\REFMAL197\Deliverable\TFL\Production\Output\"

Const C_FOLDER_INP = "output_test\"
Const C_FOLDER_OUT = "output_testit\"

Open in new window

This would mean the files are currently in output_test. If not, just leave the input folder empty.
0

Featured Post

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
Outlook Free & Paid Tools
This video shows where to find the word count, how to display it, and what it breaks down to in Microsoft Word.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now