+ Reply to Thread
Results 1 to 4 of 4

Limit VBA to pages

  1. #1
    Registered User
    Join Date
    02-26-2020
    Location
    Texas
    MS-Off Ver
    365
    Posts
    37

    Limit VBA to pages

    I am not even sure it is possible and I have searched.......

    Can you limit a VBA script to certain pages of a word document?

    Scenario -

    Every day I create documents which range from 1 to hundreds of pages.
    The beginning and end of the documents do not need to be included on the script I am running and in fact, makes my job more difficult as I must clean it all up.
    The intro pages are rarely the same amount, the the last page is always that.....the last page.
    I would like to be able to limit the script to a specific range of pages so that I don't have to clean up the results of my script.

    Currently, the code opens up with

    Please Login or Register  to view this content.
    So....I thought Hey.....what about using bookmarks.
    And then I tried......

    Please Login or Register  to view this content.
    This string is called over and over
    My poor attempt at coding failed.
    Any suggestions?

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Limit VBA to pages

    What does your VBA do to the desired pages?

    Here is one way to select a range by page number:
    Please Login or Register  to view this content.
    Then you can operate on Selection. But it would help to know what you are actually doing.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    02-26-2020
    Location
    Texas
    MS-Off Ver
    365
    Posts
    37

    Re: Limit VBA to pages

    Quote Originally Posted by 6StringJazzer View Post
    What does your VBA do to the desired pages?
    I am running a modified version of macropod's concorance script. By the way, I dig the name. Wish I still had time to play.

    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    02-26-2020
    Location
    Texas
    MS-Off Ver
    365
    Posts
    37

    Re: Limit VBA to pages

    And to be clear, the starting / ending page would change, each and every time I use the script.

+ 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. [SOLVED] vba to print the last 3 pages of a worksheet or less if document doesn't exceed 3 pages
    By lilsnoop in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 07-28-2023, 12:41 PM
  2. how to calculate ach score if lower limit and upper limit is given.
    By JAYJHA in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 07-18-2022, 06:34 AM
  3. Quality Control Upper Limit-Lower Limit Pass/Fail
    By vedaty in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-07-2019, 03:55 PM
  4. [SOLVED] Help how to limit the number pages VBA converts excel into PDF
    By bdouglas1011 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-18-2017, 07:44 PM
  5. Copy and insert row below within fixed upper limit and dynamic lower limit
    By droffel in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-27-2015, 08:57 PM
  6. Limit Excel Sheet to 1 Page (Eliminate additional pages)
    By gdwntheresa in forum Excel General
    Replies: 3
    Last Post: 01-02-2013, 09:52 PM
  7. [SOLVED] find the lower and upper limit if data is in between on that limit
    By clangeles in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-27-2012, 06:18 AM

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