I am tryiing to use VBA to manipulate the contents of inline textboxes.
I have successfully altered their name properties by using:
Selection.ShapeRange.Name = "AssignedName"
I can manipulate the text value by using:
Selection.ShapeRange.TextF
What I want to do is something like this:
ActiveDocument.TextboxesCo
But there is no such collection called TextBoxesCollection. I cannot figure out which collection owns these textboxes. They do not appear to belong to InlineShapes.
Any ideas?
Thanks,
Mike
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
I frequently use textboxes and then change the contents of the textbox using bookmarks rather than trying to identify exactly what number/name the textbox is.
Try using the code
ActiveDocument.Bookmark("T
The other advantage of using this method is that you can have a text box with more than one bookmark EG a table of partners and consultants in a letter for a law form.
Brochet,
That's a great idea. I actually tried this yesterday but gave up on that tack because when I use that method the text changes but the bookmark vanishes! Any idea how to avoid this?
Ultimately I want to manipulate text values without moving or altering the selection. Is that even possible?
Mike
What you call "inline textboxes" (which are not inline) would appear to be those you get from the Drawing Toolbar (or via Insert > Text Box).
These are members of the Shapes collection so, if you have them named, you can use:
ActiveDocument.Shapes("Ass
Have you tried this (as per Graham's first suggestion)?
Well, the initial reason I asked this question was because I could not loacte the object in either the Shapes or the Frames collection. I tried .count on both and came up with zero. But the bizarre thing is, I've just tried it again in a fresh document and sure enough the textbox was located in the Shapes collection. Very odd.
None the less, this has been a helpful discussion. I would like to ask one last question before closing and distributing the points. Is there any other way to manipulate text within the document without affecting the properties of Selection?
ActiveDocument.Shapes("MyS
works fine for textboxes. But what about ordinary blocks of text? I think altering a bookmark will move the Selection. Is it possible to specify a location like:
Set MyRange = "1 character to the right of empty bookmark 15 - to - 20 characters to the right of empty bookmark 15"
and then manipulate MyRange with vba? Assuming that is possible, would that affect Selection?
Mike
Well, the initial reason I asked this question was because I could not loacte the object in either the Shapes or the Frames collection. I tried .count on both and came up with zero. But the bizarre thing is, I've just tried it again in a fresh document and sure enough the textbox was located in the Shapes collection. Very odd.
None the less, this has been a helpful discussion. I would like to ask one last question before closing and distributing the points. Is there any other way to manipulate text within the document without affecting the properties of Selection?
ActiveDocument.Shapes("MyS
works fine for textboxes. But what about ordinary blocks of text? I think altering a bookmark will move the Selection. Is it possible to specify a location like:
Set MyRange = "1 character to the right of empty bookmark 15 - to - 20 characters to the right of empty bookmark 15"
and then manipulate MyRange with vba? Assuming that is possible, would that affect Selection?
Mike
You can define as many ranges as you like. There is only one Selection in the application.
Defining and changing ranges does not affect the Selection. I believe that it is usually preferable to use ranges, if only to avoid the display jumping about. Also you aren't confined to the active document.
set MyRange = Doc.Bookmarks("bmk15").Ran
'or perhaps
set MyRange = Doc.Bookmarks(15).Range
'(the same if the 15th bookmark is named "bmk15")
MyRange .MoveEnd wdcharacter, 20
MyRange .Movestart wdcharacter, 1
Hi Mike,
Yes, you can certainly work with Ranges other than the Selection. In general it's a good idea but there are a few things that do only work with the Selection.
To take your example, you could do:
Set MyRange = ActiveDocument.Range(Activ
MyRange.Text = "This is the text I've just added"
and the Selection wouldn't change (assuming it didn't intersect with that range, anyway)
Business Accounts
Answer for Membership
by: GrahamSkanPosted on 2005-03-09 at 01:42:43ID: 13494262
I don't believe that there is such a thing as an inline text box. The 'Inline with text' option is greyed out if you select the Layout tab in the Format/Text Box dialogue (Word 2000).
If it is still a Shape then the syntax would be
ActiveDocument.Shapes(1).T
It might be a Frame. If so then
activedocument.Frames(1).R
would be the correct syntax