Watch folder, lookup in sheet, rename - How do I approach this inVBA.

[Steve]

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

 

[NOPIK]

I think I can do the renaming portion but how to I do the file lookup
within the directory?

Thanks
Steve

Dir or FileSearch