saving to directory

[nick m]

Hi experts..

I am trying to come up with a macro that will auto save a workbook. i have so far managed to create a directory and I have gotten it to save the date and time of save, however I am stuck with the rest, what I would like to do is... save all the preceding files as say file 1 then file 2 and so on, and each time name the file in ascending order. can you please tell me if this is possible, or give me a start for me to work from. So far I have

intFreeFile = FreeFile
Open "C:ullage\CreationDate.txt" For Output As #intFreeFile
Write #intFreeFile, "Folder was created : " & Now
Close #intFreeFile

I do not claim this as my own work I have gotten it from elsewhere,

PLEASE HELP!!

 

[Jack in the UK]

Hi Nick

Can i suggest you check out feed http://www.mrexcel.com/board/viewtopic.php?topic=23644&forum=2&6

My code there will do this EDIT as needs be

HTH

JACK

PS Also follow the feed over to my original post for more infomations on this matter

Kind regards

 

[nick m]

Thank you Jack, I will have a go tomorrow morning, my eyeballs are hanging out at the mo'

I must say this is a very good site, for numpties liek me it makes learning a whole lot easier.
Regards to all Nick

 

[Jack in the UK]

Hui

Eye troubles -welcome to this board and EXCEL - standard that one im afrade my friend

Good stuff i wish you well, be sure to let me know!

HTH

Jack