I've created a macro that opens five Excel files. The fifth file links
to the other four for information. I have this one set to open last
because the first four files must be opened in order for Excel to read
them, as they are created through another program so the formatting
isn't such that it can be read by Excel until they are active.

When opening the fifth file without the macro, an option to enable
macros in the file comes up, in which Yes is the correct prompt, and
then an option to enable autolinks to other workbooks comes up, in
which, again, Yes is the correct prompt. Upon answering these
questions, appropriate data in this file is updated with the info from
the others. However, when using the macro, it isn't linking the other
files as needed. Is there something that must be done to make this
happen? I created the macro using the "Record Macro" option, so it
should be capturing everything I did, but I'm wondering if it doesn't
capture the answers to the opening prompts for some reason?


--
telewats
------------------------------------------------------------------------
telewats's Profile: http://www.excelforum.com/member.php...o&userid=30270
View this thread: http://www.excelforum.com/showthread...hreadid=514962