Results 1 to 1 of 1
  1. #1
    Join Date
    Jan 2009
    Posts
    1

    Unanswered: Macro for Word Data to Txt files

    Hi All,

    I need a urgent help in macro writing, I am not a VBA Master but I can understand the how to copy and paste the code and run the macro.
    I am trying to use the following macro. It is working perfectly fine in word. I am pasting this code in word macro and when i click the run macro it will save the word data to txt file. but my problem is that i am downloading the statement from the bank website in a single word file and i want to save the word file in txt format but "ACCOUNT WISE". Like I have downloaded 25 word statement for different 25 customers and copy the all word statements in a word file. then i want to save these 25 word statements into 25 txt files in a folder (BUT ACCOUNT WISE SAVE ). Following macro is converting the whole data to txt format in a single file but i am unable to save the account wise txt file. so plz help me in this regard.
    (Important:- I CANNOT DOWNLOAD IN TXT FORMAT BCOZ MY BANKWESITE IS GIVING ME ACCESS ONLY ON PDF AND WORD FORMAT.

    Sub test_import()
    '
    ' test_import Macro
    ' ChangeFileOpenDirectory "C:\data\"
    ActiveDocument.SaveAs FileName:="santosh.txt", FileFormat:=wdFormatText, _
    LockComments:=False, Password:="", AddToRecentFiles:=True, WritePassword _
    :="", ReadOnlyRecommended:=False, EmbedTrueTypeFonts:=False, _
    SaveNativePictureFormat:=False, SaveFormsData:=False, SaveAsAOCELetter:= _
    False
    Application.Quit
    End Sub


    Plz help urgent
    Last edited by santoshdream; 01-22-09 at 19:59.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •