?
Solved

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

Posted on 2013-01-25
3
Medium Priority
?
825 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 35

Assisted Solution

by:Robert Schutt
Robert Schutt earned 2000 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 2000 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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
Outlook for dependable use in a very small business   This article is about using the Outlook application (part of Microsoft Office) in a very small business, or for homeowners where dependability and reliability are critical requirements. This …
This video shows where to find the word count, how to display it, and what it breaks down to in Microsoft Word.
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…

777 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