From Excel, Open a word document and goto a page questionSolved/Closed

Question

Hello, 

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

so you could either answer here or on the other thread, I don't mind

Many thanks,
Scooble

rizvisa1 · Answer

this also does not work ?
WordApp.Selection.Goto What:=wdGoToPage, Which:=wdGoToNext, Name:="8"

Anonymous User · Answer

yes, your right, that doesn't work too. It opens up word and navigates to page 29 (which happens to be section 8)

Anonymous User · Answer

I tried using a working document and it would go to section instead of page.  
when I use a blank document with lets say 5 pages, it always went to page 1.  

I used several different lines of code and they all went to page 1 on the blank document;  

WordApp.Selection.Goto What:=wdGoToPage, Which:=wdGoToNext, Name:="5"  
WordApp.Selection.Goto What:=wdGoToPage, Count:=5 
WordApp.Selection.Goto wdGoToPage, wdGoToNext, , 5  


does it work with you?

Anonymous User · Answer

thats great, and it seems to work, however, what do these numbers mean?
What:=1, Which:=2,

From Excel, Open a word document and goto a page question

4 responses

Similar discussions

Subscribe To Our Newsletter!