Hello-- This question relates to problems when launching Excel from a link on
a web page.

SCENARIO: I have an Excel workbook with some pretty involved VBA code. The
code creates a budgeting and reporting application against an OLAP database.
A new requirement has come up to make this workbook available to around 300
users. To send the workbook to these users individually would become a
nightmare in maintenance and support. So, I have put the file on a shared
drive. Now, the powers that be want the workbook launched from a link on a
web page.

Here are my issues:

1) The code was not originally designed to run through a browser, so I plan
to have the link open the Excel application. Is there a way to have the
workbook opened from a link without it asking the user to "Open" or "Save"
the file?

2) Originally the workbook was an Excel Add-in (.XLA), so it never asked to
enable/disable macros. Now (because of the way new requirements are setup), I
need to have a "main menu" (my first sheet) with some buttons. Therefore it
prompts to enable/disable. I have thought about writing some type of LAUNCHER
in VB6 which opens the workbook, and compile as .EXE-- and have the link call
the launcher. Anyone have any thoughts or experience with this?

3) I have a menu that is created during Workbook_Open(). Problem is, that
during testing of the link (after opening Excel application and then the
Workbook), every thing is working fine except when I choose something from
the menu-- it trys to reopen the workbook from the server. I'm not sure why
this is happening. This does not happen if I launch Excel and the workbook
outside of the browser.

4) Any helpful links on deploying Excel or Excel on the Web??

Thanks for your help!

DAN