I am trying to create a xls file with a counter that adds one to the counter
everytime it is opened. However, I do not want to save the file.

Does it have to be done in an external file? Can it be saved in some
variable?