hi... I made this macro to save a file based on the name in a cell but i get
a runtime 1004 error method 'savea' of object_workbook failed if there is already a file of that name in the folder and i select no or cancel instead of yes.... any way to fix that???
also... is it possible to save just the active worksheet to a location and not the whole workbook?
a runtime 1004 error method 'savea' of object_workbook failed if there is already a file of that name in the folder and i select no or cancel instead of yes.... any way to fix that???
also... is it possible to save just the active worksheet to a location and not the whole workbook?