I am using a VBA File Dialog to Save As my existing file to another name. That seems to work, but if I then go and manually use "Save" later, I get an error.
The debugger says that it is failing on this call:
The filename it's accessing cannot be read on screen, it runs off the edge of the dialog box. But I think it is an xml file within my main Excel file, with the same name.
In other words, MyExcelFile \ MyExcelFile.xml.
Any idea why that would be happening? It's true that file does not exist. But I don't get that error when saving the original file, and the file doesn't exist there either. In that case, the Export just fails. But if I save after I have used the 'Save As' dialog from VBA , I get the runtime error. I hope that explanation is clear.
Thanks for any ideas about what could be causing this!