PDA

Click to See Complete Forum and Search --> : Excel and Internet Explorer OLE function?


SuperPhil
May 16th, 2003, 12:52 AM
Hi folks,

I created a litte Excel VBA Program. The end user has to open a browser, go to a website. then he clicks on a button in the webpage in order to download some files in XLS format.
Some users have a problem with OLE functions:
Instead of having a message box asking him "Save as..."
an Excel workbook is opened, embedded in the browser.
I'd like to know if there is any possibility to enable /disable this OLE function?

Thanks for any advice
SuperPhil

alex_read
May 19th, 2003, 01:49 AM
Unfortunately, this cannot be set via code & is down to the individual machines' browser settings.

SuperPhil
May 19th, 2003, 06:39 AM
alex_read,

Thanks for your advice and as you said, Dave Peterson explained to me how to do that:
==============

Start Windows Explorer (not MSIE).
View|folder Options (win98 version)--Tools|Options (in others????)
File Type tab
Scroll down to the Microsoft Excel Worksheet item
Click on Edit
There's an option to "browse in the same window"
Uncheck it.



===========================
Regards,
Phil