Auto saving after changes.

  • Thread starter Thread starter DuckMan2k
  • Start date Start date
D

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
 
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.
Click to expand...

Can't you place a save line in the code that imports the collection of information after
it is done.??
 
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.
 
in the thisworkbook code module:

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