VBA Generated File Cannot Be Saved

[GonzoB]

Hi Gurus,

I created a VBA which does some calculation, populates two spreadsheets in the excel file and at the end of the script generates 2 new files on the users computer. For me it works perfectly fine: I run the macro and the files are created in my folder. That's all, nothing else happens for me.

However another user reported that when he runs the macro, first a pop up message asks whether he wants to save the file or not (for me there's no such pop up window appearing). He clicks on yes, but the files are not created. He figured out that this is because he had other unsaved excel files open. When he closes these, we can successfully create the new files with the macro.

I was trying to find the reason for this behavior but I could not. I could not even reproduce the same things. For me there's no pop up window asking whether I want to save the files or not and the VBA always generate the 2 new files, regardless what other excels I have open.

Do you have any ideas
a) why excels asks certain users whether I want to save the file or not?
b) why unsaved excel files blocking the VBA to create new excels?

Thanks in Advance

 

[rlv01]

Without seeing the code that saves the file, it is hard to say.