VBA via AppleScript - Word Table PICT help requested
VBA via AppleScript - Word Table PICT help requested
- Subject: VBA via AppleScript - Word Table PICT help requested
- From: Bill Planey <email@hidden>
- Date: Sat, 27 Mar 2004 19:14:14 -0600
Hello,
I am struggling to create an AS call to VBA that would allow me to:
1) determine the presence or not of PICT-style tables (EMF tables that were
pasted into Word as Pictures, rather than linked to the original Excel
data).
2) move sequentially through these PICT objects (which are not inline, but
floating) and copy each one into a container field in FileMaker Pro.
Here is what I could record in Script Editor, during the action of
mouse-clicking on the first table in the Word doc and choosing the Copy
command:
tell application "Microsoft Word"
activate
do Visual Basic " ActiveDocument.Shapes(\"Picture 75\").Select"
copy
end tell
...so it is obvious that "Picture 75" is the reference to this object, and
the fact that I discovered by the same method that the second object was
"Picture 5" means that there is no correlation between the number of the
object as Word sees it and the order of its appearance in the document.
Nor, as I discovered, does it mean that there is necessarily a "Picture 4"
just because there is a Picture 5.
So, I need a way to either make a list of these types of objects present in
the document, arranged in the order of appearance, so that I can actually go
through the document and sequentially select/copy them.
I do have enough experience calling VBA from AppleScript to have made
handlers and to also have incorporated globals into the VBA commands from
AppleScript.
I do not know enough Visual Basic to accomplish this particular task, so any
help in doing this would be greatly appreciated.
Thanks,
Bill Planey
_______________________________________________
applescript-users mailing list | email@hidden
Help/Unsubscribe/Archives:
http://www.lists.apple.com/mailman/listinfo/applescript-users
Do not post admin requests to the list. They will be ignored.