Thanks, Stefan.

Unfortunately, it's still not working. It's strange because it worked
before, saving the output file in the directory where I saved the
excel file.

I wonder if I crashed my Excel program when stopping the macro using
the task manager?

Andreas