Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel comes up gray screen when first launched | Excel Discussion (Misc queries) | |||
Excel minimizes when a linked file launched | Excel Discussion (Misc queries) | |||
Auto-displaying a template when Excel is launched | Excel Discussion (Misc queries) | |||
How do I determine how excel was launched | Excel Programming | |||
Can you tell how Excel is launched? | Excel Programming |