Inserting Objects into Excel Vx

Scripting Forums AppleScript | Mac OS X
#1

Hi

I having to spend the next few months embedding thousands of word documents into a workbook. In order to do this manually I have to click through various dialog boxes and browse folders for each and every file. Good old excel won’t let me stop recording a macro at the “browse” dialog window. :frowning:

Would an applescript be capable of getting me to the insert object browse window to a pre defined directory? As I just have to click on 2 lines below before the previously inserted object before inserting the next one, could applescript just go through how ever many files are in the dir until it’s inserted every one?

Your thoughts & comments would be much appreciated.

Thanks in advance

Rob…

#2

Two ideas:

FIRST
Record a macro all the way through one file then edit it. It’s in VB Script but the syntax is not so bizarre as you might be able to short-cut the macro yourself with some tinkering.

SECOND
Everyone seems to forget Excel is recordable by Script Editor, at least for everything but the “wizards” (like the ChartMaker Wizard). So set Script Editor or ScriptDebugger to record, go through one entire import example, then modify the resultant script for your needs. You should be able to take the recorded bit then put it inside a larger manually-written script that can loop through a directory of files.