Limitations of shared workbooks

[DieuSoleil]

I have a workbook which has a sub that sends a sql query to an external
(Oracle) database. When I check the share workbook property so that
changes can be made by 1+ users at the same time, the sub returns the
following error:

"Run-time error '1004': this command is not available in a shared
workbook"

I can see why there is a restriction on doing this in a shared workbook,
but is there any workaround?

Thanks.

 

[Wei-Dong XU [MSFT]]

Hi,

Thanks for posting in the group.

I have reviewed your thread. Currently I am finding somebody who could help
you on it. We will post back in the newsgroup as soon as possible.

If there is anything unclear, please feel free to post in the group and we
will follow up there.

Best Regards,
Wei-Dong Xu
Microsoft Product Support Services
Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Peter Huang]

Hi DieuSoleil,

Did the problem occur when only you open the shared workbook on the network
share?
When the error occurred , if you press debug, which code line did debugger
stop at?
Also here is article which may be the problem, you may take a look.
How to Identify and Remove PLDT/CAR/SGV Macro Viruses
http://support.microsoft.com/?id=176807

Best regards,

Peter Huang
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.

 

[DieuSoleil]

Peter,

Thanks for the reply.

The error occurs when I call the sub that sends off the SQL query,
irrespective of whether I'm using the file on my client or whether I'm
accessing it via the network in IE (v6).

When the workbook is not shared it works perfectly in both environments.

Even when I created a workbook with only 1 procedure (to send off a
query to the db) I had the same problem when it was shared, likewise the
problem occurs when I try and re-run a procedure generated using the
macro recorder so I'm sure the problem is not related to my code.

When the error occurs I am not given the opportunity to access the
debugger: the button is greyed out, as is continue.

I have checked for the viruses you mentioned but none of them are
present on my system.

I'm using MS Excel 2000 SP3 on Windows 2000 SP4.

Thanks again for the assistance.
Regards,
Iain