From Excel, Open a word document and goto a page question
Solved/Closed
Anonymous User
-
29 Jan 2013 à 06:21
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 1 Jun 2013 à 18:07
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 1 Jun 2013 à 18:07
Related:
- Word vba wdgotopage constant value
- Wdgotoitem wdgotopage value - Best answers
- Vba wdgotopage constant value - Best answers
- Ms word pdf extension - Download - Other
- Vba find - Guide
- Ms word mod apk for pc - Download - Word processors
- Word full screen - Guide
- Free word processor - Guide
4 responses
rizvisa1
Posts
4478
Registration date
Thursday 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
29 Jan 2013 à 06:58
29 Jan 2013 à 06:58
this also does not work ?
WordApp.Selection.Goto What:=wdGoToPage, Which:=wdGoToNext, Name:="8"
WordApp.Selection.Goto What:=wdGoToPage, Which:=wdGoToNext, Name:="8"
Anonymous User
29 Jan 2013 à 07:56
29 Jan 2013 à 07:56
yes, your right, that doesn't work too. It opens up word and navigates to page 29 (which happens to be section 8)
rizvisa1
Posts
4478
Registration date
Thursday 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
29 Jan 2013 à 22:05
29 Jan 2013 à 22:05
is it possible to sample word document that can be test. If you could post it on some public file share site like speedyshare.com and post back link to the ACTUAL FILE back here
Anonymous User
30 Jan 2013 à 03:55
30 Jan 2013 à 03:55
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;
does it work with you?
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?
rizvisa1
Posts
4478
Registration date
Thursday 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
2 Feb 2013 à 14:13
2 Feb 2013 à 14:13
Ah I see
The issue is this, you are trying to run the code from non- word application. It does not know what these mean "wdGoToPage", "wdGoToNext"
Try this
WordApp.Selection.Goto What:=1, Which:=2, Name:="8"
The issue is this, you are trying to run the code from non- word application. It does not know what these mean "wdGoToPage", "wdGoToNext"
Try this
WordApp.Selection.Goto What:=1, Which:=2, Name:="8"
rizvisa1
Posts
4478
Registration date
Thursday 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
16 Mar 2013 à 11:56
16 Mar 2013 à 11:56
you are welcome anon.
Anonymous User
30 May 2013 à 09:18
30 May 2013 à 09:18
thats great, and it seems to work, however, what do these numbers mean?
What:=1, Which:=2,
What:=1, Which:=2,
rizvisa1
Posts
4478
Registration date
Thursday 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
1 Jun 2013 à 18:07
1 Jun 2013 à 18:07
from help
Word Developer Reference
Document.GoTo Method
Returns a Range object that represents the start position of the specified item, such as a page, bookmark, or field.
Syntax
expression.GoTo(What, Which, Count, Name)
expression Required. A variable that represents a Document object.
Parameters
Name Required/Optional Data Type Description
What Optional. Variant .
The kind of item to which the range or selection is moved. Can be one of the WdGoToItem constants.
Which . Optional. Variant.
The item to which the range or selection is moved. Can be one of the WdGoToDirection constants.
Count . Optional. Variant.
The number of the item in the document. The default value is 1. Only positive values are valid. To specify an item that precedes the range or selection, use wdGoToPrevious as the Which argument and specify a value for the Count value.
Name Optional. Variant.
If the What argument is wdGoToBookmark, wdGoToComment, wdGoToField, or wdGoToObject, this argument specifies a name. Only positive values are valid. To specify an item that precedes the range or selection, use wdGoToPrevious as the Which argument and specify a value for the Count argument.
Remarks
When you use the GoTo method with the wdGoToGrammaticalError, wdGoToProofreadingError, or wdGoToSpellingError constant, the Range that's returned includes any grammar error text or spelling error text.
Too Much detail to add here. See the help and you will find all you seek
Word Developer Reference
Document.GoTo Method
Returns a Range object that represents the start position of the specified item, such as a page, bookmark, or field.
Syntax
expression.GoTo(What, Which, Count, Name)
expression Required. A variable that represents a Document object.
Parameters
Name Required/Optional Data Type Description
What Optional. Variant .
The kind of item to which the range or selection is moved. Can be one of the WdGoToItem constants.
Which . Optional. Variant.
The item to which the range or selection is moved. Can be one of the WdGoToDirection constants.
Count . Optional. Variant.
The number of the item in the document. The default value is 1. Only positive values are valid. To specify an item that precedes the range or selection, use wdGoToPrevious as the Which argument and specify a value for the Count value.
Name Optional. Variant.
If the What argument is wdGoToBookmark, wdGoToComment, wdGoToField, or wdGoToObject, this argument specifies a name. Only positive values are valid. To specify an item that precedes the range or selection, use wdGoToPrevious as the Which argument and specify a value for the Count argument.
Remarks
When you use the GoTo method with the wdGoToGrammaticalError, wdGoToProofreadingError, or wdGoToSpellingError constant, the Range that's returned includes any grammar error text or spelling error text.
Too Much detail to add here. See the help and you will find all you seek
