evibesmusic
asked on
How to force xls file to open in Excel rather than IE6 browser window?
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?
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?
ASKER
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.
Good luck.
jppinto