Auto saving after changes.

[DuckMan2k]

Hello All.

I have a workbook that I want to be autosaved after changes are made, and in
the same workbook a single worksheet to be saved as a CSV file (also after
changes have been made). Is there a macro or does anyone know how i would be
able to acomplish this?

Thankyou
Micheal

 

[Ron de Bruin]

Do you mean after every change you make??

 

[Ron de Bruin]

Hi DuckMan2k

you mail me private with this

It is an automated spreadsheet, it imports a collection of information every
10-15 minutes, I want it to save after the information has arrived, or even
if excel could do 5 or 10 minute checks to see if there have been any
changes.

Can't you place a save line in the code that imports the collection of information after
it is done.??

 

[Derrick Robinson]

Thats an interesting question especially the auto save after changes have
been made. It would be nice if the answer was posted for the benefit of some
of us who would like to see the solution.

 

[Tom Ogilvy]

in the thisworkbook code module:

Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As
Excel.Range)
thisworkbook.Save
End Sub