Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Need to convert Wordperfect Macro to Office Word

Posted on 2008-06-18
4
Medium Priority
?
748 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
3 Comments
 
LVL 77

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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

Most everyone who has done any programming in VB6 knows that you can do something in code like Debug.Print MyVar and that when the program runs from the IDE, the value of MyVar will be displayed in the Immediate Window. Less well known is Debug.Asse…
Microsoft Word is a program we have all encountered at some point, but very few of us have dug deep into its full scope of features, let alone customized it to suit our needs. Luckily making the ribbon (aka toolbar, first introduced in Word 2007) wo…
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…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…
Suggested Courses
Course of the Month14 days, 23 hours left to enroll

577 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