Excel save

  sms 15:46 11 Jun 2005
Locked

I am running a data logger to an excel file to display various info.
I would like to run a macro that will save the info on a daily basis however I do not want to override the previos file. Could anyone advise me how I can do this
Thanks

  VoG II 15:54 11 Jun 2005

Does click here help?

  sms 14:38 12 Jun 2005

thanks will give it a try although it will take me time to digest as I am not an expert

  sms 12:12 13 Jun 2005

Hi VoG
tried the macro and works well.only problem now is if i close the program and re-open and then run the macro it says the file already exists and do i want to override this file which means i would be overwrite all previous files. how can i overcome this
thanks in advance

  VoG II 12:45 13 Jun 2005

For this to work, you have to open the last workbook saved. Provided that you do this there is no problem with over-writing files.

If you would like me to send you a working example, please send me a message by clicking on the yellow envelope next to my name.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

How secure is your Wi-Fi?

AMD vs Intel: we put the most powerful desktops for designers and artists head-to-head

iPhone tips & tricks

Les meilleurs ordinateurs portables 2017