Home > Archive > Visual Basic Syntax > March 2006 > How can I rename files with namws on MS Excel columns?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
How can I rename files with namws on MS Excel columns?
|
|
|
| I have an excel sheet with information as below:
s/n|Surname |First_name |Picture |Rt_thumb |Lft_Thumb
1 John James d:\aaa.jpg d:\bbb.jpg d:\ccc.jpg
2 Festus Kujore d:\ddd.jpg d:\eee.jpg d:\fff.jpg
I need a code to copy the files (aaa.jpg, ddd.jpg into e:\pictures as
John_james_pic and Festus_Kujore_pic), and (bbb.jpg, eee.jpg, into
e:\Rt-Th as John_james_Rt and Festus_Kujore_Rt), and (ccc.jpg, fff.jpg,
into e:\Lft as John_james_Lft and Festus_Kujore_Lft).
Can any one pls help? Thanks in advance.
| |
| Robert Ellis 2006-03-23, 7:08 pm |
| Amas,
You can do that inside Excel, by writing some VBA code. You can reference
Microsoft Scripting Runtime (FileSystemObject) to help build the relevant
directory paths and to copy the files themselves.
Regards
Robert
"amas" <amas_essien@yahoo.co.uk> wrote in message
news:1142840238.545768.132860@e56g2000cwe.googlegroups.com...
>I have an excel sheet with information as below:
>
> s/n|Surname |First_name |Picture |Rt_thumb |Lft_Thumb
> 1 John James d:\aaa.jpg d:\bbb.jpg d:\ccc.jpg
> 2 Festus Kujore d:\ddd.jpg d:\eee.jpg d:\fff.jpg
>
>
> I need a code to copy the files (aaa.jpg, ddd.jpg into e:\pictures as
> John_james_pic and Festus_Kujore_pic), and (bbb.jpg, eee.jpg, into
> e:\Rt-Th as John_james_Rt and Festus_Kujore_Rt), and (ccc.jpg, fff.jpg,
>
> into e:\Lft as John_james_Lft and Festus_Kujore_Lft).
>
>
> Can any one pls help? Thanks in advance.
>
|
|
|
|
|