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
Bookmarks