Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Programming / July 2005

Tip: Looking for answers? Try searching our database.

Programming Re Document Save

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Graham L - 20 Jul 2005 13:51 GMT
Hi,

I'm using Word97 and have approx 100 unformatted text files in the following
directory

\\FINPC13\SHARE FIN01\NR6 Draft .rpt\

I want to open each in turn, perform identical formatting on each file and
then save the file as a word document within the same directory.
The following programming performs the first part of this routine (I think!)

Sub RunNR6()

Dim myFile As String
Dim PathToUse As String
Dim myDoc As Document

PathToUse = "\\FINPC13\SHARE FIN01\NR6 Draft .rpt\"

myFile = Dir$(PathToUse & "*.rpt")

While myFile <> ""

Set myDoc = Documents.Open(PathToUse & myFile)

   Selection.WholeStory
   Selection.Font.Size = 8
   With ActiveDocument.PageSetup
       .LineNumbering.Active = False
       .Orientation = wdOrientLandscape
       .TopMargin = InchesToPoints(0.5)
       .BottomMargin = InchesToPoints(0.5)
       .LeftMargin = InchesToPoints(1)
       .RightMargin = InchesToPoints(0.5)
       .Gutter = InchesToPoints(0)
       .HeaderDistance = InchesToPoints(0.5)
       .FooterDistance = InchesToPoints(0.5)
       .PageWidth = InchesToPoints(11.69)
       .PageHeight = InchesToPoints(8.27)
       .FirstPageTray = wdPrinterDefaultBin
       .OtherPagesTray = wdPrinterDefaultBin
       .SectionStart = wdSectionNewPage
       .OddAndEvenPagesHeaderFooter = False
       .DifferentFirstPageHeaderFooter = False
       .VerticalAlignment = wdAlignVerticalTop
       .SuppressEndnotes = False
       .MirrorMargins = False
   End With
               

I am struggling with the code which will then save each file (the active
document at the time) as a fully formatted word document within the following
directory:-

\\FINPC13\SHARE FIN01\NR6 Draft .rpt\

Help gratefully appreciated.

Graham
Jonathan West - 20 Jul 2005 17:13 GMT
Hi Graham,

Look up the SaveAs method of the Document object. You would need to add
something like this to your macro

myFile = Left$(myFile, Len(myFile) - 3) & "doc"
ActiveDocument.SaveAs FileName:=myFile, FileFormat:=wdFormatDocument
ActiveDocument.Close SaveChanges:=wdDoNotSaveChanges

Signature

Regards
Jonathan West - Word MVP
www.intelligentdocuments.co.uk
Please reply to the newsgroup
Keep your VBA code safe, sign the ClassicVB petition www.classicvb.org

> Hi,
>
[quoted text clipped - 57 lines]
>
> Graham
FL Consultant - 22 Jul 2005 08:58 GMT
Jonathan,

Would you look at my post How to update mailmergefields and MailMerge Doc
with VBA.  I would appreciate some additional input and suggestions.

Thank you
Signature

FL Consultant

> Hi Graham,
>
[quoted text clipped - 66 lines]
> >
> > Graham
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.