+ Reply to Thread
Results 1 to 2 of 2

Delete Blank Pages in Word using Excel Macro

  1. #1
    Registered User
    Join Date
    06-12-2013
    Location
    USA
    MS-Off Ver
    excel 2007
    Posts
    9

    Delete Blank Pages in Word using Excel Macro

    I am using word to edit a document. At the end of the editing I need to delete out the blank pages. I have a macro that works for it in word, but am having trouble "converting" it into something that doesn't return an error in Excel.

    This is the code that deletes blank pages.

    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    The issue I have now is here: "Object doesn't support this property or method"

    Please Login or Register  to view this content.
    I do have the microsoft word 12.0 object library selected. Changing the wording from Selection.Goto to Content.Goto doesn't work either, as then I get an object required error. Any help would be greatly appreciated with getting this macro to work.

    Also any other general tips manipulating word docs from excel vba would be awesome.
    Last edited by frongi; 06-18-2013 at 03:30 PM.

  2. #2
    Registered User
    Join Date
    06-12-2013
    Location
    USA
    MS-Off Ver
    excel 2007
    Posts
    9

    Re: Delete Blank Pages in Word using Excel Macro

    figured it out, needed to feed it wdApp and do wdApp.Selection

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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