Excel save

  sms 15:46 11 Jun 2005

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

  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

OnePlus 5T review: Hands-on

Illustrator Andrés Lozano on his improv line work, brazen use of colours & hand sketching

iPhone X review

Comment envoyer gratuitement des gros fichiers ?