Word.Range

Serpico · #1 03-08-2017, 12:22 AM

Hello macropod,

Thank you for you reply.

If I understand you right, the prefix of the variable type range (in this case), is only to specify the application your running from (word.range -> word app)? Ok, that sounds clear for me. But look below on the example (it is from Gerg Maxey):
Why does he refer to the word app? His code is to be used anyhow in VBA Word?

Code:

Sub InsertInBookmarkIII()
Dim oRng As Word.Range
   Set oRng = ActiveDocument.Bookmarks("bmInBookmark").Range
   oRng.Text = InputBox("What is your favorite color?")
   ActiveDocument.Bookmarks.Add "bmInBookmark", oRng 
lbl_Exit:
   Exit Sub
End Sub

Thank you

macropod · #2 03-08-2017, 12:50 AM

Quote:

Originally Posted by Serpico

But look below on the example (it is from Gerg Maxey)
Why does he refer to the word app? His code is to be used anyhow in VBA Word?

You should ask him. It may be just a quirk of his programming style - as is the quite unnecessary use of:
lbl_Exit:
Exit Sub

PS: When posting code, please use the code tags, indicated by the # button on the posting menu. Without them, your code loses much of whatever structure it had.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Distribute text in one cell across a range of cells (overcoming selection.range.cells.count bug)	slaycock	Word VBA	0	02-18-2017 07:00 AM
Find if Date range falls within another range	Triadragon	Excel	3	05-02-2016 11:48 AM
Name a Range in a Word Document and then copy that range to the end of the doc w button click	DanNatCorning	Word VBA	1	04-29-2016 10:47 PM
Set Excel Range using Word	gbrew584	Word VBA	3	12-07-2015 01:51 PM
Through VBA, export range from Excel to Word	duugg	Word VBA	0	08-24-2009 07:50 PM