Recent content by Eseke

Thanks Molby it helped me for the most part.

It didn’t work but that will come because of a part of the macro that I use to name my saved workbook. The macro that I use is as followed: ChDir "C:\ resultaten\ " ActiveWorkbook.SaveAs Filename:= _ "C:\ resultaten\resultaten" & Format$(Now, "YYMMDD_HHMMSS") & ".xls"...

I will try it. Thanks for the quick response.

I wanted to know if it was possible to automatically answer the message box “Do you want to save the changes in “workbook”” with NO. This is because I already have a macro that saves the sheet under a unique name. And after saving resets the entire sheet so when I’m done I can start without any...

That was exactly what i had in mind Andy. I have seen some macro's that can check if there is a file with that name. Will see how it will turn out. But you have been a great help. Thanks

Thanks guys. I wanted to keep the allready saved file. But is it possible to have a systemtic number after the date? Like 20070127001

Thanks Andy. But what do I do need to add to the code if I want to use it multiple times per day?

Yes it was going to be a date specific file name

Saving in Excel with dynamic filename I'm trying to make a macro that makes a save of a workbook. So far I managed to get the code but now I wanted to make the filename dynamic. But I haven’t got the skill to make such a macro so all help is welcome. The code I have so far is: ChDir...