LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 12
Default In Excel, why does my VB not work when launched from IE ?

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel comes up gray screen when first launched G Excel Discussion (Misc queries) 0 November 5th 08 06:36 PM
Excel minimizes when a linked file launched Gregg Excel Discussion (Misc queries) 0 February 28th 06 05:11 PM
Auto-displaying a template when Excel is launched Heidi Excel Discussion (Misc queries) 1 July 28th 05 03:10 AM
How do I determine how excel was launched Gilgamesh[_2_] Excel Programming 2 January 21st 05 07:04 AM
Can you tell how Excel is launched? Gail Hurn Excel Programming 3 January 11th 05 05:47 PM


All times are GMT +1. The time now is 03:51 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"