Launch Excel from the Web

DANNER

New Member
Joined
Oct 23, 2006
Messages
1
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!
 

Some videos you may like

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.

Watch MrExcel Video

Forum statistics

Threads
1,113,875
Messages
5,544,816
Members
410,635
Latest member
phoenix7771
Top