rename file

G

Guest

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
 
B

Bob Phillips

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Parse and rename multiple .pdf files 4
Importing an image in VBA 5
Rename files with VBA 8
Copying a Picture From Cell Comment 0
Watch folder, lookup in sheet, rename - How do I approach this inVBA. 1
Dynamically Rename Files Using VBA 0
rename sheets(tabs) 10
Code execution is correct but generates Error :The file you aretrying to open is in a different form 3

Top