Improve company productivity with a Business Account.Sign Up

x
?
Solved

How to force xls file to open in Excel rather than IE6 browser window?

Posted on 2011-02-10
5
Medium Priority
?
736 Views
Last Modified: 2012-05-11
Experts,

Some of my users still have IE6 as part of their company's PC builds.  As such, whenever I offer an Excel file via a weblink, they get the option to open the file or save.

These xls files contain macros.  When the files are saved to a user's local machine the macros function fine.  If the user chooses open, the file opens within the IE6 browser window and the macros fail.

Is there a way to force the file to bypass IE6 when opening and open in Excel itself?  Can this be done server side via HTML?
0
Comment
Question by:evibesmusic
  • 3
  • 2
5 Comments
 
LVL 33

Expert Comment

by:jppinto
ID: 34867053
The user just needs to right click on a saved Excel file and choose "Open with", select Excel and check the option where it says something like "use always this program to open this type of file" or something like that. It will assign always Excel to open .xls files in the future.

jppinto
0
 
LVL 33

Expert Comment

by:jppinto
ID: 34867067
0
 

Author Comment

by:evibesmusic
ID: 34867101
That would be simple enough but, some of these users don't even know how to do that.

The most simple solution would be to allow the macros to work within the browser as intended.  This may be a macro error issue too...this is the error they see:

Run Time Error '1004'
Method 'Display Alerts' of object '_Application' failed
0
 

Accepted Solution

by:
evibesmusic earned 0 total points
ID: 34889477
@All:

This error is common among XLS and IE6 interactions.  The issue is well documented across the web.  This is macro based, xls solution.

Cheers.  Thanks for the attempt to help.

http://php.kennedydatasolutions.com/blog/2008/02/05/internet-explorer-breaks-excel-pivot-tables/
0
 

Author Closing Comment

by:evibesmusic
ID: 34932103
This solution provides a solution to this common problem.  Turns out this error has been around for a long time and many people have tried to conquer it.

Good luck.
0

Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Manually copying shapes and their assigned macros one by one to a new location can be tedious, but if you use the Excel utility workbook attached to this article, the process will be much quicker and easier.
An ASP.NET Web Form User Control is not newly introduced in ASP.NET. In fact, it was an old technology yet still playing a role to generate web content, especially when we want to use it to have a better and easy way to control part of the web conte…
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
How to create a custom search shortcut to site-search Experts Exchange using Google in the Firefox browser. This eliminates the need to type out site:experts-exchange.com whenever you want to search the site. Launch your Bookmark Menu: Press 'Ctrl +…

595 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question