Hi, folks!
I'm really new to VBA, but I've been able figure out most things that I want Excel to do. However, this problem has me stumped!
Like others I've seen posting to this (and other) message boards, I want Excel to open a Word document and extract information from it. I made my "big breakthrough" yesterday when I got Excel to be able to open a Word doc and control it a bit (I tested it out by seeing if I could maximize the window - success!). And, I can get to to search for strings formatted in a certain way, and assign values to created object according to whether it was able to find each of the strings. But the closest I can get it to selecting the Microsoft Graph Charts is getting it to place the curser just under it. I used the Selection.GoTo What:=wdGoToObject, Which:=wdGoToFirst command, and that's what happened - but even then, inconsistently.
I need to be able to run this macro for a whole bunch of small documents that follow about the same format, but not exactly. These weren't created with the intention of someone ever being able to extract data from them with Excel; rather, each one was simply created from a Word "template" (not an official Word/Office template, but what was practically used as a template) containing the Microsoft Graph Chart "templates" (same definition) ready to have new data typed into it.
I'm hoping if someone can just point me in the right direction to get Excel to recognize/open these old objects, then I can take it from there. As long as a macro can be created for it, I'm open to making any modifications to the format/file type/etc. to "prepare" it for extraction. But it'd probably be too much to go through and do it manually for each of the charts in the many, many individual documents.
Thanks!
Susie
Bookmarks