Using an instance of Excel in Internet Explorer

[Leonard of Quirm]

Hello all,
I have no experience of using Excel from within Internet Explorer, so any help would be much appreciated!

I have created a workbook containing a macro which has been uploaded to our intranet via a content management system. It is intended to be used by a community of users who activate the link which opens a copy of the workbook within Internet Explorer (rather than in Excel itself).

The workbook functions as follows:
1. Users select a value (let's call it X) from a drop down list in one of the cells and press enter.
2. Pressing enter activates a macro which unhides some hidden sheets and performs lookups using X and then returns the results (based on the lookups) on the original sheet visible to the user, after re-hiding all the lookup sheets.
3. Some supporting text is inserted on the original sheet to explain the results given for X.

Unfortunately, I cannot post my code. But is there some way in which I have to adopt my code to make it work within Internet Explorer (is this possible even)? As it is, nothing happens after performing step 1.

Many thanks,

Matt

 

[scifibum]

Hi,

You should not have to alter your code. If you are saving the file as an Excel workbook, even if you are viewing the spreadsheet in Internet Explorer, Excel is still running to display the spreadsheet and the VBA code runs in Excel, not in IE. If this is your situation, then the problem might be with your security settings. What is your macro security level in Excel?

If you are saving the spreadsheet as a web page, then the VBA will not be saved with it. You would need to take a different approach to programming a spreadsheet saved as a web page.

 

[Leonard of Quirm]

Thanks for the reply Scifibum, but I've already come to a decision based on other findings.

It turns out that our internal system controls are set up so as to disable VBA code run from within the content management system so my initial requirements are kind of scuppered here. I think my best option is to redevelop the tool using conventional workbook based formulae, conditional formatting lookups etc. in order to achieve the same output but without any VBA support. This way, users will be able to use the functionality from the website without compromising my version control worries.

Thanks anyway.

Matt