I created a spreadsheet that has been widely distributed (well 20-30
people) and I came across a bug in my code. The bug was an easy fix
but I have no way to update all the distributed programs without a
complete mess.

Is there a way to do this?

Thanks ahead of time!


--
ynotravid
------------------------------------------------------------------------
ynotravid's Profile: http://www.excelforum.com/member.php...o&userid=13476
View this thread: http://www.excelforum.com/showthread...hreadid=498976

1. Create a new .xls file with the revision number in the filename.
2. e-mail the new file to your recipients
--
Gary's Student


"ynotravid" wrote:


I created a spreadsheet that has been widely distributed (well 20-30
people) and I came across a bug in my code. The bug was an easy fix
but I have no way to update all the distributed programs without a
complete mess.

Is there a way to do this?

Thanks ahead of time!


--
ynotravid
------------------------------------------------------------------------
ynotravid's Profile: http://www.excelforum.com/member.php...o&userid=13476
View this thread: http://www.excelforum.com/showthread...hreadid=498976

Gary's Student,

Would the receiver of this new file have to copy and paste his dat
from the old file into the new file? Or would the new file and ol
file merge without having to copy/paste and without losing any of th
data

--
securityma
-----------------------------------------------------------------------
securityman's Profile: http://www.excelforum.com/member.php...nfo&userid=882
View this thread: http://www.excelforum.com/showthread.php?threadid=49897

um... yeah. I guess should have mentioned that there is a ton of data.
Just getting the data transfered properly to a new version takes a
couple hours.


--
ynotravid
------------------------------------------------------------------------
ynotravid's Profile: http://www.excelforum.com/member.php...o&userid=13476
View this thread: http://www.excelforum.com/showthread...hreadid=498976

if the only change is in the modules, than u could just export them and
then import the new code into the existing xls files. you could probly
write a macro that would do it for the user.


--
TheIrishThug
------------------------------------------------------------------------
TheIrishThug's Profile: http://www.excelforum.com/member.php...o&userid=29682
View this thread: http://www.excelforum.com/showthread...hreadid=498976

Irish, you are brilliant!

I'm off to try to figure out how.

Thanks for the suggestion!


--
ynotravid
------------------------------------------------------------------------
ynotravid's Profile: http://www.excelforum.com/member.php...o&userid=13476
View this thread: http://www.excelforum.com/showthread...hreadid=498976