Take a look at this blog post:
One caveat: These scripts are done in FrameScript instead of ExtendScript. If you don't have FrameScript, it costs $149 (see http://www.framescript.com). Please let me know if you are interested in the scripts. Thanks.
This sounds like exactly what I need.
I purchased FrameScript Friday night but the license is not working. At the moment, I am waiting to hear back on Marjorie at FrameScript (hopefully today) and then I will pickup the script you are talking about.
I assume that the script works in the regular FrameMaker 11 files and there is no need to convert over to MIF for it to work. Is that correct?
I already have a spreadsheet (Microsoft Excel 2010)
Thanks again for the quick response.
As soon as I hear from Marjorie, you will be hearing from me.
Thank you very much.
This probably won't be immediately helpful, but I wanted to point out that ExtendScript is fully capable of this, but your "asap" requirement is a problem unless you are willing to pay somebody else. Graphic path management is not terribly difficult at a basic level, but reading and/or writing to FM tables is tricky. Reading and writing to an Excel spreadsheet is even more tricky. To do this yourself, you'll need significant expertise with ES. It sounds like buying the script from Rick might be your only quick option, and as I know Rick, I suspect you'll receive a quality product.
I wholeheartedly agree with Russ' suggestion to hire Rick Quattro for this job. However, instead of reading and writing an Excel document from ExtendScript directly, I would suggest using a CSV file instead. In my script I use CSV files extensively, after having first tried to read/write Excel direct. The difference is a runtime of seconds versus hours, and you can guess which script version was fastest. It should not be a problem to read/write CSV from Excel, as this is a one-time operation per book (I guess), whereas the read/write operations executed by the script would be many per file.
I do not have any time available right now, otherwise I could offer you a script. But I am sure Rick can do a fast job and he will probably charge you less (I guess life is less expensive in his neck of the woods or he is just a much nicer guy). I have had Rick create scripts for me in the past and I was more than satisfied with his work.
Ciao and good luck