Hello! I'm beginner in VBA. I already figured out how to save the active worksheet under a specific filename. However, the worksheet has cell references to other worksheets in the original workbook. How can I avoid that (guess will be some kind of copy and paste special values)? Also, how can I define where to save the new file?

Thanks!