Results 1 to 7 of 7

Opening a word document from excel and goto a specific page - question

Threaded View

  1. #1
    Registered User
    Join Date
    01-28-2013
    Location
    Sussex, England
    MS-Off Ver
    Excel 2003
    Posts
    17

    Opening a word document from excel and goto a specific page - question

    I have an Excel document which I have inserted some VBA code to open a word document;

    Set WordApp = CreateObject("word.Application")
    WordApp.documents.Open NetworkAddress & FileName
    WordApp.Visible = True
    But I also want it to navigate to a page of my choosing, in this example, I have chosen page 8 as a random example;

    WordApp.Selection.Goto wdGoToPage, wdGoToNext, , 8 ' trying to go to page 8
    But this just opens up the document and goes to page 29, which happens to be 'section' 8

    I also tried this;

    Selection.Goto What:=wdGoToPage, Which:=wdGoToNext, Name:="8"
    But the debugger stopped it because it thinks that there is a syntax error

    Could someone please explain the full method and give an example of the code that you place in Excel to open up a word document and navigate to a specific page

    BTW - the same question has been asked here;
    http://www.mrexcel.com/forum/excel-q...d-go-page.html

    Many thanks,
    Scooble
    Last edited by scooble; 01-28-2013 at 07:28 AM.

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