Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Watch folder, lookup in sheet, rename - How do I approach this inVBA.
All - I working with a reporting tool that outputs excel files with reportname as the xls file name. Our internal system only sees file with a specific name format. In reviewing the documentation for the reporting tool - I see that I can call an Excel VBA module. So I want to create a macro that: For each file located in a folder Look in sheet "Catalog" If report name is in column A " example A2" then rename report to the value in Column C "Example C2" else iqnore. So if reportname.xls is in sheet1-column a2 (ThisName.xls) then change name to value in c2 (ThatName.xls) I think I can do the renaming portion but how to I do the file lookup within the directory? Thanks Steve |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
unprotect 1st sheet in every workbook in a folder and change month inS1 & year in T1 & rename all workbooks | Excel Programming | |||
How to create a copy of a folder having five files in it, & rename | Excel Worksheet Functions | |||
rename files in a folder | Excel Programming | |||
rename all files in a folder | Excel Programming | |||
rename folder o files with value from inside each wbk | Excel Programming |