Old value of cell

[Guest]

Hi Masters

Somebody have a idea what the better way to get the old value of a cell.I did a code for to accumulate the value in the comment using the worksheet change event, but I didn't find a good way.

Thanks,

 

[Frank Kabel]

Hi
depends on several things:
- do you want to do this only for a single cell or for many -> maybe a
hidden worksheet whih stores the data and also use the worksheet_change
event
- only some values -> maybe a static variable / a static array within
the worksheet_change event

 

[Guest]

Hi Fran

Well, In fact, I have 2 or 3 columns with due dates of purchase orders. During the month, users changes this dates due any situations (Delay in supply, problem with transportation, bad planning...). I was thinking to develop a solution using the event worksheet_change to save informations about this change (user, reason of this replanning, what field was changed, old value and new value, date and hour of change)
This would be a good way to understand the real cause of problems in suppliers and to provide statistical figures about the processe

Thank you, your attention. have a nice day.

 

[Frank Kabel]

Hi
though this could be done this sound more like a database application
for me. You're trying to create an audit trail for your orders and this
is (IMHO) much easier done for example in MS Access

--
Regards
Frank Kabel
Frankfurt, Germany

Hi Frank

Well, In fact, I have 2 or 3 columns with due dates of purchase

orders. During the month, users changes this dates due any situations
(Delay in supply, problem with transportation, bad planning...). I was
thinking to develop a solution using the event worksheet_change to save
informations about this change (user, reason of this replanning, what
field was changed, old value and new value, date and hour of change).

This would be a good way to understand the real cause of problems in

suppliers and to provide statistical figures about the processe.

 

[Guest]

This is True Frank

May be a real application in .Net with SQL Server. Excel for this is very fragile

Best regards and thank you to share your time

 

[Frank Kabel]

This is True Frank.

May be a real application in .Net with SQL Server. Excel for this is very fragile.

Best regards and thank you to share your time.

</rant modus on>
Though one could argue if .NET is a REAL application <vbg>
</rant modus ooff>

Couldn't resist but yes this is IMHO a better solution
Frank

 

[onedaywhen]

</rant modus on>
Though one could argue if .NET is a REAL application <vbg>
</rant modus ooff>

In a nutshell, what's the arguement against?

--

 

[Frank Kabel]

Hi

</totally OT on>
We just took part in a really large transition from old mainframe
systems (of an insurance company) to a .NET envrionemnt (startegic
decision in favor for .NET instead of J2EE).

Many problems J2EE has finally overcome begin again with .NET (message
broking, concurrent users in different locations, performance,
stability). One example: MS finally acknoledged that the garbage
collector (in our specific environment) dos not work)

Yes .NET is (IMHO) one of the best things MS has developed and it will
probably improve significantly over time, but as of know your a more or
less a beta tester in production environments. No problem for small
applications

And to be honest: of course you encounter similar problems in the J2EE
environments but they are a little bit older and have improved over
time.

And again just I personal opinion from personal experience
</totally OT off>

 

[onedaywhen]

Thanks, Frank. It's good to get a sensible, 'real life', non-MS
perspective on the world.

--