Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
rename excel file name | Excel Discussion (Misc queries) | |||
problem after rename of file | Excel Discussion (Misc queries) | |||
How to set SAVE AS file name to equal A1 contents when rename file | Excel Discussion (Misc queries) | |||
Rename File | Excel Programming | |||
Rename file | Excel Programming |