+ Reply to Thread
Results 1 to 6 of 6

Simple VBA question but 'Word' related

  1. #1
    Registered User
    Join Date
    05-09-2014
    MS-Off Ver
    Excel 2010
    Posts
    18

    Simple VBA question but 'Word' related

    Hi all, I have a 199 page document that I need to 'process'. I used to be fairly handy with macros but haven't touched them for 10years + so a little rusty. The document is a PDF that has been imported to word so won't be 'set up' in a standard way.

    First job - there is a watermark on each page that I need to get rid of. It s not in 'master pages' but rather appears as a different image on each page.

    I've recorded a macro to get started and it seems that the image is called Picture <X> with x being incremented on each page .... so what I want is along the lines of:
    For x = 1 To 199 ActivePage.Shapes("Picture" & x).Select
    Selection.ShapeRange.Delete
    Application.Browser.Next
    next x

    You might not be surprised to hear that this doesn't work. The error returned is RunTime error 424: Object Required.

    Any thoughts?

  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: Simple VBA question but 'Word' related

    Cross-posted at: http://www.vbaexpress.com/forum/show...251#post409251
    Please read Excel Forum's Cross-Posting policy in rule 8: http://www.excelforum.com/forum-rule...rum-rules.html
    Cheers,
    Paul Edstein
    [Fmr MS MVP - Word]

  3. #3
    Registered User
    Join Date
    05-09-2014
    MS-Off Ver
    Excel 2010
    Posts
    18

    Re: Simple VBA question but 'Word' related

    Apologies Paul. Does your helpful post cover the requirement to link?

    (I've not had any answers on either forum yet ... guessing it must be a lot harder than I though?

  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: Simple VBA question but 'Word' related

    Quote Originally Posted by BremhillBob View Post
    Apologies Paul. Does your helpful post cover the requirement to link?
    If that's the only cross-post, yes.
    Quote Originally Posted by BremhillBob View Post
    (I've not had any answers on either forum yet ... guessing it must be a lot harder than I though?
    I, for one, answered your question at VBA Express. Perhaps you should read my other post there...

  5. #5
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,460

    Re: Simple VBA question but 'Word' related

    Administrative Note:

    We would very much like to help you with your query, however the thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.

    Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

    Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

    (Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  6. #6
    Registered User
    Join Date
    05-09-2014
    MS-Off Ver
    Excel 2010
    Posts
    18

    Re: Simple VBA question but 'Word' related

    Hi Paul,
    just wanted to thank you again. Your help much appreciated

    Bob

+ 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] Create a counter related to a word
    By rcprito in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 02-28-2013, 11:10 AM
  2. [SOLVED] Commandbutton in a wkb question(add-in related)
    By Bishonen in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-31-2012, 12:55 PM
  3. Simple Macro - Sum of values that are related to a sprecific word chosen by you.
    By Adam Brave in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 03-02-2012, 03:31 PM
  4. Need some VBA help... Word-related
    By MitchU in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-20-2010, 09:10 AM
  5. [SOLVED] Input Box Related Question
    By Barb Reinhardt in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-19-2006, 02:10 PM
  6. Input Box Related Question
    By Barb Reinhardt in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-19-2006, 11:10 AM
  7. I have a VB related question,...
    By javabeens in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-07-2005, 01:05 PM
  8. Function Related Question
    By Sandeep Arora in forum Excel General
    Replies: 1
    Last Post: 02-02-2005, 04:06 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