View Single Post
  #6   Report Post  
Posted to microsoft.public.word.docmanagement
DerbyDad03 DerbyDad03 is offline
external usenet poster
 
Posts: 48
Default How do I Select an Object with VBA?

Thank you for the response.

Actually, just recording the Paste-Special operation works and is
repeatable.

The only thing missing is that the IconLabel simply says Adobe Acrobat
Document. Is there any way to set the IconLabel to the original file
name?

On Mar 1, 1:58*pm, Greg Maxey wrote:
I will try again since you have apparently not seen my reply on 28 Feb
that is showing up in the Office Online Discussion groups but not
here.

In this case you would probably just select the shape in the document
and then run:

Sub Test()
Dim oILShape As InlineShape
Set oILShape = Selection.InlineShapes(1)
oILShape.OLEFormat.ConvertTo ClassType:= _
"AcroExch.Document.7", DisplayAsIcon:=True, IconFileName:= _

"C:\WINDOWS\Installer\{AC76BA86-7AD7-1033-7B44-
A90000000001}\PDFFile.ico",
IconIndex:=0, IconLabel:="Acrobat Document"
End Sub

The recorded often adds a lot of superfilous fluff. E.g., there is no
need to covert an InLineShape to a Shape before converting to a icon.

Easier yet would probably be to simply use EditPaste Special and
paste as an icon.

On Feb 28, 1:41*pm, DerbyDad03 wrote:

I am trying to learn how to Select an object in a Word doc via VBA.


Let me give you an example.


First - I know that I can insert this particular object as an Icon
linked to the file, but if someone can tell me why this conversion
code doesn't work, I'm hoping I'll learn something about selecting
objects via VBA. In other words, this question isn't about the best
way to convert an object, it's about how to select an object.


OK, so I have a new document open. I start the recorder and then
perform these steps:


1 - Go to my desktop
2 - Right click a PDF document and select Copy
3 - Go back into the document and use Edit...Paste
4 - Right-click the object and use the PDF Convert option to create a
PDF Icon
5 - Stop the recorder


This produces the following code:


Sub ConvertToIcon()
* * Application.WindowState = wdWindowStateNormal
* * Selection.Paste
* * ActiveDocument.Shapes("Object 2").Select
* * If Selection.Type wdSelectionShape Then
* * * * Selection.InlineShapes(1).ConvertToShape.Select
* * End If
* * Selection.ShapeRange(1).OLEFormat.ConvertTo ClassType:= _
* * * * "AcroExch.Document.7", DisplayAsIcon:=True, IconFileName:= _
* * * * "C:\WINDOWS\Installer\{AC76BA86-7AD7-1033-7B44-
A90000000001}\PDFFile_8.ico" _
* * * * , IconIndex:=0, IconLabel:="Acrobat Document"
End Sub


Now here's the problem: *If I copy another PDF and then run this code,
I get an error related to the object not being found, or it tries to
convert the same object over again, etc. Depending on what I've done
before I run the code, the error will change.


It's obvious that it is not selecting the most recently pasted object
because "Object 2" is hard coded. How do I get the code to select the
last object that was pasted without actually knowing what number that
object is?


Thanks.