If I have the full filepath to a workbook set to a variable...can I change the name of that workbook with VBA WITHOUT opening the workbook and resaving it?
Or another way to think about it...say you have a workbook sitting on the desktop..you click once on the name, and windows will then let you type in a new name for the file...I would like to do the same thing via VBA..
Thanks All,
Jason
Or another way to think about it...say you have a workbook sitting on the desktop..you click once on the name, and windows will then let you type in a new name for the file...I would like to do the same thing via VBA..
Thanks All,
Jason