rename file
is it possible to rename a picture file using VBA? for example in file
C:/files/ i have picture.jpg, can i change that file name to range("a1").value ? thanks in advance |
rename file
Use the Name statement
Dim OldName, NewName OldName = "C:\files\i have picture.jpg NewName = range("A1").Value Name OldName As NewName -- HTH RP (remove nothere from the email address if mailing direct) "choice" wrote in message ... is it possible to rename a picture file using VBA? for example in file C:/files/ i have picture.jpg, can i change that file name to range("a1").value ? thanks in advance |
All times are GMT +1. The time now is 11:32 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com