Unable to open excel sheet in Protected mode from VB 6.0

ourspt

New Member
Joined
Jan 26, 2005
Messages
3
Hi,

I am working on a project in VB6.0 and SQL Server. We use MS Excel for our reports. We also

use server side COM+ components.

We have a situation where we are not able to open some of the reports in 'protected' mode

(i.e, to prevent the users from making changes to the excel report). When we try to open

these in protected mode, the application is crashing, giving a Dr. Watson error.

When we change the VB code to open the excel reports in 'Unprotected' mode, the applcation

works alright. But in this case, the users would be able to change the reports as they like.

Why am I not able to open these excel reports in protected mode from my VB6.0 exe?

Is there a way, where we can prevent the users from making changes to the excel report, even

if we open it in 'unprotected' mode?

We tried using the 'Read Only Recommended' option but that allows the users to make changes

and save changes as some other file name (although the users are prevented from making

changes to the same file) and this cannot be allowed in our application.

Any help in this regard is greatly appreciated.

Thanks in advance
ourspt
 

Some videos you may like

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.

Watch MrExcel Video

Forum statistics

Threads
1,123,259
Messages
5,600,573
Members
414,389
Latest member
MarkElla

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top