VB Code Works Perfect...but Not when the File is Shared

[TEAM]

I have an excel file with a number of modules and workbook codes built to limit access and provide differing functionality. The workbook is made up of about 30 sheets that different people input data in. When the file is placed on a share drive it deletes sheets at odd times and sometimes deletes itself according to the users.

Are there different programming commands to make an excel VB file work on a share drive?

[TEAM]

I am using Excel 2003 and those who are sharing and accessing this file are using Excel 2002. Is that more likely to be the problem?


Thanks!!

[Dave Peterson]

Do you mean that the workbook is shared (tools|share workbook) or just that the
workbook is stored on a common share on a network?

====

I don't use Shared workbooks very much, but I wouldn't think the versions would
be too much of trouble.

Have you tried deleting a worksheet in a shared workbook?

It's one of the things that isn't allowed.

====
But I've never seen excel delete a workbook or worksheets from a file stored on
a shared drive. (But the highest version of xl we used was xl2k.)

I'd keep an eye out for user error.



TEAM wrote:
>
> I am using Excel 2003 and those who are sharing and accessing this file
> are using Excel 2002. Is that more likely to be the problem?
>
> Thanks!!
>
> --
> TEAM
> ------------------------------------------------------------------------
> TEAM's Profile: http://www.excelforum.com/member.php...o&userid=22810
> View this thread: http://www.excelforum.com/showthread...hreadid=467660

--

Dave Peterson

[TEAM]

Thanks Dave.

I asked the user, and the file is actually stored on a shared drive, but apparently not set up as a shared file.

You are definitely right about the user error part. That was my first guess, so I am trying to get access to the location where they are using the file and I will test it myself.


Thanks again.