Are they being opened in separate instances of Excel when launched from IE
and within the same instance when launched from MS Excel?

--
Regards,
Tom Ogilvy



"David C" wrote:

I have a small VB project which works fine when launched by MSExcel, but
fails when launched by hyperlink from a webpage (IE5).

The file booking.xls opens 4 other xls files and copies data from them, but
when launched from within IE, it opens the files OK but cannot then move
focus to them in order to copy cells.

Does IE require different ways of linking? I used workbooks.open (4 times)
to find and open the subordinate files, then windows(bookname).activate plus
sheets(sheetname) to switch to each of then in turn. When launched from IE,
this produces a Run-time error '9' (Subscript out of range) - which I guess
means that the bookname parameter is not picked up.