Excel save

  sms 15:46 11 Jun 05
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 05

Does click here help?

  sms 14:38 12 Jun 05

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 05

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 05

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.

How to get Windows 10 for free | How to install Windows 10: There is still a way to avoid paying…

1995-2015: How technology has changed the world in 20 years

Alex Chinneck’s giant ice cube Christmas tree at Kings Cross

Apple rumours & predictions 2017: The iPhone 8, new iPads, and everything else you should expect fr7…