Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
ourspt
 
Posts: n/a
Default Unable to open excel sheet in Protected mode from VB 6.0

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




--
ourspt
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
unable to open Excel file by double clicks Renyan Excel Discussion (Misc queries) 2 January 16th 05 02:07 AM
Unable to open Template in Excel 2003 NYBrianK Excel Discussion (Misc queries) 0 January 5th 05 10:33 PM
Excel Files Won't Open From Shortcut ConfusedNHouston Excel Discussion (Misc queries) 5 December 31st 04 07:25 PM
auto update an open excel sheet over network, with mutiple users crumkerr Excel Worksheet Functions 1 November 29th 04 12:47 PM


All times are GMT +1. The time now is 11:55 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"