Auto Save on a cell value

[datahouse]

Hi All,

I have an excel file that I would like to be able to save to c:\live when the value in cell b10 is 1. i would like this file to be saved as date and time if this is possible.

Thanks In Advance

Gav

[TMS]

Do you manually change cell B10 or is it the result of a formula? If it's a manual change, you could use a VBA Worksheet Change event to monitor the cell and cause the file to be saved. Using the date and time as part of the file name is not a problem, although you can't use "/" or ":".

If it's the result of a formula, you might have to monitor the cells that feed into cell B10 or use the Calculate event and check it there. Not sure of the impact on performance.


Regards, TMS

[datahouse]

I suppose it is a manual input. Could you give me an example of VBA Worksheet Change event to monitor the cell and cause the file to be saved Please.

Thanks

Gav