Thanks for the info...however, much too complicated for a novice such as
myself. However, I have found a way that works for me. Since all the files
I need are in the same directory, I just hold down the "ctrl" key and select
all 4-5 linked files and then select "open". Voila...all files are opened!

"JMB" wrote:

Forgot one thing - after the Dim statement - you should put the following

On Error Resume Next

this will force the code to continue executing in the event it can't find
one of the linked files (if the linked file got moved or deleted) - it'll
just skip the file it can't find.


"DroKoz" wrote:

I am having to convert all files from Quattro Pro to Excel. When I open a
document in Quattro Pro which has several other documents linked, the program
will automatically open all the linked documents.

How do I do this in Excel?

As far as I have been able to figure out, Excel only opens the selected
document and then updates the linked information, but won't automatically
open the linked documents. The only way to open the linked documents is to
go to "Edit-Links-Open Source" for each linked document.

Any help would be appreciated!