Excel and Browsers

[EliseFreedman]

Hi All

I have an excel form that is posted on our intranet. The problem I have is that depending on the way the users machine is set up, it either opens in Internet Explorer or Excel. If it opens in Internet Explorer then the built in code doesnt work.

I have added some code to determine if it is opening in IE and if so, to display a warning asking the user to save the spreadsheet before completing and submitting it. However, i was wondering if there was any way in which having determined that it was opened in IE, I could automatically close the IE instance of excel and reopen the spreadsheet using excel.

 

[xlbo]

I have had a similar issue int eh past - it is local user settings but should be able to be controlled by group policy if you have that available..

If not then I'm not sure - you could experiment with simply opening a new excel instance from your current one and working from there but that may run into issues with what you can / can't do within IE anyway...

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[Bluejay07]

This could be user settings, however it also depends on which version of internet explorer you are using.

If you are using IE6, then the default behaviour is to open Microsoft office products in Internet Explorer. Here is a patch that fixes this issue:

http://support.microsoft.com/kb/162059/en-us

In later versions of IE, the patch is already in place and should open in excel (if not, try the patch).

If the user has admin permissions on their computer, you can also check the following (based on Windows XP):
- Open any folder.
- Select 'Tools' then 'Folder Options' from the top menu bar.
- Select the 'File Types' tab
- Scroll to and select the extension for 'XLS'
- Click the 'Advanced' button.
- Ensure that the checkbox for 'Browse in same window' is NOT checked.


If at first you don't succeed, then sky diving wasn't meant for you!