Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Rename Files according to Excel
Hello. I am new to macros and such. I am trying to make an excel spreadsheet that will convert files (with known names) into more descriptively named derived from some cells in excel..I have no idea where to start :( -- nima ------------------------------------------------------------------------ nima's Profile: http://www.excelforum.com/member.php...o&userid=30408 View this thread: http://www.excelforum.com/showthread...hreadid=509181 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Rename Files according to Excel
nima,
assuming you have you all your data on a worksheet, something like: Dim FileName As Range For Each FileName In ThisWorkbook.Worksheets("Data").Range("FileNames") Name FileName.Value As FileName.Offset(0, 1).Value Next You should error checking to ensure the the files exist, names valid, etc. NickHK "nima" wrote in message ... Hello. I am new to macros and such. I am trying to make an excel spreadsheet that will convert files (with known names) into more descriptively named derived from some cells in excel..I have no idea where to start :( -- nima ------------------------------------------------------------------------ nima's Profile: http://www.excelforum.com/member.php...o&userid=30408 View this thread: http://www.excelforum.com/showthread...hreadid=509181 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I rename files that are related. | Excel Discussion (Misc queries) | |||
Help to rename files | Excel Worksheet Functions | |||
Rename Files | Excel Programming | |||
Import and Rename Files | Excel Programming | |||
Need Macro to rename excel files | Excel Programming |