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 |
All times are GMT +1. The time now is 12:46 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com