I have a macro that exports several charts into 5 different sheets and rename the sheets - no problem. But I need to get the Excel doc to be named the client number of the client name, I have chosen as current selection. I have searched the Net and this forum but haven't found anything I can get to work.