+ Reply to Thread
Results 1 to 8 of 8

Without Opening Folder, Change Font Size and View

  1. #1
    Forum Contributor
    Join Date
    05-23-2017
    Location
    Bang, India
    MS-Off Ver
    MS Office 2007
    Posts
    221

    Without Opening Folder, Change Font Size and View

    I have MS Word 2007 Documents in drive F and a Folder with name "Designs" which hold many sub folders. Can someone suggest a code to do the following; without opening the word documents is it possible to Change Font Name to Times New Romans and Size 11. Also it has to have the Print Layout View.
    Please shoot your expert opinions on this......Thank you for all your time in advance....

  2. #2
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: Without Opening Folder, Change Font Size and View

    It is not possible to make such changes without opening the files concerned. For a macro to process all documents in a folder and its sub-folders, see:
    http://www.msofficeforums.com/word-v...tml#post117894
    Naturally, you'd need to adapt the code there to suit your formatting requirements. Do note that making such changes will also update the documents' date/time stamps. Also, the preferred way of modifying the fonts in a document is to modify the relevant Styles; overriding the Style definitions makes the documents harder to maintain and more prone to corruption.
    Cheers,
    Paul Edstein
    [Fmr MS MVP - Word]

  3. #3
    Forum Contributor
    Join Date
    05-23-2017
    Location
    Bang, India
    MS-Off Ver
    MS Office 2007
    Posts
    221

    Re: Without Opening Folder, Change Font Size and View

    I have MS Word 2007 Documents in drive F and a Folder with name "Designs" which hold many sub folders. Can someone suggest a code to do the following; without opening/with opening the word documents is it possible to Change Font Name to Times New Romans and Size 11. Also it has to have the Print Layout View. Please suggest your expert views on this......

  4. #4
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: Without Opening Folder, Change Font Size and View

    I have already answered that, including providing a link to some code to do most of the processing and advising the preferred way of addressing such formatting issues. Asking the same question over & over is not going to change the answer...

    You should adapt the code in the link I provided to suit your needs. If you have problems doing that, post back with details of the specific issues you're having.

    As for Print Layout View, that has nothing to do with the document properties.

  5. #5
    Forum Contributor
    Join Date
    05-23-2017
    Location
    Bang, India
    MS-Off Ver
    MS Office 2007
    Posts
    221

    Re: Without Opening Folder, Change Font Size and View

    I dont know for some reason the link was not opening up and it was hanging most of the time.......when we tried here...... can u please post the code if you have......thanks in advance....

  6. #6
    Forum Contributor
    Join Date
    05-23-2017
    Location
    Bang, India
    MS-Off Ver
    MS Office 2007
    Posts
    221

    Re: Without Opening Folder, Change Font Size and View

    code for to work in a batch of folders...

  7. #7
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: Without Opening Folder, Change Font Size and View

    The code in the link I posted (there is nothing wrong with the link) loops through all documents in a selected folder and its sub-folders. With each document, it performs a Find/Replace. You need only modify that part of the code to have it do what you want.

  8. #8
    Forum Contributor
    Join Date
    05-23-2017
    Location
    Bang, India
    MS-Off Ver
    MS Office 2007
    Posts
    221

    Re: Without Opening Folder, Change Font Size and View

    well i got the link, it is working..............thanks for the info......

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Search for text filtered by a font size range in all pdf files in a folder
    By dink2344 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-13-2016, 07:41 PM
  2. Change font size keeping the cell size fixed
    By mayurpatil in forum Excel General
    Replies: 1
    Last Post: 07-09-2015, 01:52 PM
  3. How to using comma style without change font & font size
    By rameshtupe in forum Excel General
    Replies: 1
    Last Post: 07-11-2013, 01:19 PM
  4. [SOLVED] Change default font and font size on COMMENTS in cells
    By Thistledown in forum Excel General
    Replies: 4
    Last Post: 11-23-2012, 09:26 AM
  5. How to change the font/font size in a combo box
    By brendas in forum Excel General
    Replies: 2
    Last Post: 11-07-2005, 04:00 PM
  6. [SOLVED] font is 10 pt:how do i change the font size in a combo box?
    By nkruppa in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-10-2005, 05:05 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1