Hello,
I'm trying to save a file to a specified folder with a custom filename depending on the contents of certain cells.
Everything used to work fine, however suddenly I got Runtime error 1004: the specified dimension is not valid for the current chart type whenever the macro gets to the save-routine.
Code looks as follows:
To generate the filename:
And then to save the file:
The code chokes at ActiveWorkbook.SaveAs fileSaveName, FileFormat:=xlOpenXMLWorkbookMacroEnabled.
Does anyone have any idea what may cause this problem? Note that a chart appears in the worksheet, but I don't refer to it anywhere in the code...
Bookmarks