Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VB Code Works Perfect...but Not when the File is Shared
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 ------------------------------------------------------------------------ TEAM's Profile: http://www.excelforum.com/member.php...o&userid=22810 View this thread: http://www.excelforum.com/showthread...hreadid=467660 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VB Code Works Perfect...but Not when the File is Shared
I am using Excel 2003 and those who are sharing and accessing this fil are using Excel 2002. Is that more likely to be the problem? Thanks! -- TEA ----------------------------------------------------------------------- TEAM's Profile: http://www.excelforum.com/member.php...fo&userid=2281 View this thread: http://www.excelforum.com/showthread.php?threadid=46766 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
VB Code Works Perfect...but Not when the File is Shared
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
VB Code Works Perfect...but Not when the File is Shared
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 firs guess, so I am trying to get access to the location where they ar using the file and I will test it myself. Thanks again -- TEA ----------------------------------------------------------------------- TEAM's Profile: http://www.excelforum.com/member.php...fo&userid=2281 View this thread: http://www.excelforum.com/showthread.php?threadid=46766 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
code works - need to save | Excel Discussion (Misc queries) | |||
Code works for any WBK except the PMW | Excel Programming | |||
How do I convert works file to excel without works software? | Excel Discussion (Misc queries) | |||
Office 2003 - "autocomplete" in file | open or file | save no longer works | Excel Discussion (Misc queries) | |||
Why won't this code works | Excel Programming |