View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
billy600 billy600 is offline
external usenet poster
 
Posts: 1
Default Continuing VBA development whilst workbook is in shared use.


Hi,

I've developed an app using Excel2002 with some VBA code. Phase one i
now complete and out with a couple of users for testing.

I'd like to continue with phase 2 development whilst people are usin
phase one.
My previous coding experiance is with development environments where a
executable can be compiled and release allowing users to use and me t
continue with development. I guess this is not applicable with Exce
based work.

From what I can figure out my options are -

1. let users work on a restricted timetable and develop during period
when they are not using.
2. take a copy of the workbook, rename it and use that for developmen
work and copy code changes back into the 'live' workbook. (I can;t se
this working very well).

Can anyone suggest any alternative strategies?

Many thanks,
Will

--
billy60
-----------------------------------------------------------------------
billy600's Profile: http://www.excelforum.com/member.php...fo&userid=1137
View this thread: http://www.excelforum.com/showthread.php?threadid=27519