?
Solved

Need to convert Wordperfect Macro to Office Word

Posted on 2008-06-18
4
Medium Priority
?
729 Views
Last Modified: 2012-08-13
Need to convert this macro to Word. The wordperfect macro is below.  

Application (A1; "WordPerfect"; Default; "US")
FileSave ("C:\testfolder\file.prn"; ASCIIStandard!)
Close ()

I recorded a macro in Word 2003/2007, saving it to the location, however, I do not know how to migrate the ASCIIStandard over. It keeps saving it in a *.txt format.

I don't now much about programming in VB, any help will be appreciated.
0
Comment
Question by:awgit
[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
4 Comments
 
LVL 76

Expert Comment

by:GrahamSkan
ID: 21818145
How does ASCIIStandard differ from a text file?
Perhaps you could post the recorded macro and tell us what that does wrong.
0
 

Author Comment

by:awgit
ID: 21822508
The problem was that it was saving the file as fileprn.txt instead of file.prn

I redid the Macro today and it seems to be working. Word does throw in a lot of additional information, is all of this required for the Macro to work?

Sub ALNT1()
'
' ALNT1 Macro
' Macro recorded 6/19/2008 by IT Network Services
'
    ChangeFileOpenDirectory "\\filer2\atlas\dept\rev\revact\"
    ActiveDocument.SaveAs FileName:="tmp1.prn", FileFormat:=wdFormatText, _
        LockComments:=False, Password:="", AddToRecentFiles:=True, WritePassword _
        :="", ReadOnlyRecommended:=False, EmbedTrueTypeFonts:=False, _
        SaveNativePictureFormat:=False, SaveFormsData:=False, SaveAsAOCELetter:= _
        False, Encoding:=1252, InsertLineBreaks:=False, AllowSubstitutions:=False _
        , LineEnding:=wdCRLF
    Application.WindowState = wdWindowStateNormal
End Sub
0
 
LVL 1

Accepted Solution

by:
Computer101 earned 0 total points
ID: 22144462
PAQed with points refunded (500)

Computer101
EE Admin
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say 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 is the result of a quest to better understand Task Scheduler 2.0 and all the newer objects available in vbscript in this version over  the limited options we had scripting in Task Scheduler 1.0.  As I started my journey of knowledge I f…
Not long ago I saw a question in the VB Script forum that I thought would not take much time. You can read that question (Question ID  (http://www.experts-exchange.com/Programming/Languages/Visual_Basic/VB_Script/Q_28455246.html)28455246) Here (http…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Suggested Courses
Course of the Month12 days, 9 hours left to enroll

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