INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!

Talk With Other Members
Be Notified Of Responses
To Your Posts
Keyword Search
One-Click Access To Your
Favorite Forums
Automated Signatures
On Your Posts
Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

LINK TO THIS FORUM!

Tek-Tips LinkedIn^® Group

Join our
LinkedIn^® Group!

Hook up with past and present colleagues and classmates quickly.

Partner With Us!

"Best Of Breed" Forums Add Stickiness To Your Site

(Download This Button Today!)

Feedback

"...Congratulations on a brilliant idea and a great site..."

More...

Geography

Where in the world do Tek-Tips members come from?

Click Here To Find Out!

Tek-Tips Shirts!

Get your
Tek-Tips Forums
SWAG here!

Home > Forums > Programmers > Languages > VBA Visual Basic for Applications (Microsoft) Forum

Excel and Browsers

Read More Threads Like This One

EliseFreedman (Programmer)

29 May 12 6:56

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 (MIS)

30 May 12 1:56

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: How to get the best answers before you ask a question

Bluejay07 (Programmer)

22 Jun 12 10:34

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!

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Back To Forum

Back To VBA Visual Basic for Applications (Microsoft)