Can I do this? Change a name of a file without opening it?

[JasonC71]

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

 

[Weaver]

Check out:

http://www.mrexcel.com/forum/showthread.php?t=69402

 

[JasonC71]

Thank you.

Jason