Hi everybody, I went through every solution I've found online already and also asked AI for help but nothing.
I keep getting Run-time error '1004': Method 'SaveAs' of object '_Workbook' failed in my code.
This is the code:
One thing to point out is that this code works in 3 out of 4 instances in other files, but in some, I keep getting this error.
Any clues what could be the reason? One thing the AI pointed out is the I can't use SaveAs to save to URL/sharepoint, but as I said it works in other files.