Have you tried file format 51?
Could there be any protection on the folder you are writing to that may prevent you saving a file there?
Does it work with an alternate file path?
Sorry for all of the questions - it's the way my brain works.
https://learn.microsoft.com/en-us/of...l.xlfileformat