Script to check text for string ".jpg"

[ctinmotion]

I have templates that I use to build a database for importing in to DB2. Before we send the data over, we need to run a script which checks the data in certain columns (L, M, N) to make sure that it contains the text ".jpg". Is there a quick and easy macro I can set up so I can run it on all of my templates?

TIA!

 

[ctinmotion]

Kris, when I run the script it opens a file dialog box but it does not display the actual files in the folder. Is there a way I can remove that dialog box alltogether? It might be looking for an actual .xlst (template) file maybe? The workbooks are not saved as actual templates, I just use the word "template" because it is how we refer to them internally. They are all just straight .xls files with Columns A through BA with data. Maybe that is why they are not displaying in the file dialog box?

I would ideally like to just save the script to my Personal.xls file so that I can run it on any open workbook. Is that possible or am I trying to do something that can't be done?

Thanks so much for your help!

 

[Krishnakumar]

Hi,

You don't need to pick any files. Just pick the folder(I assume the selected folder contains only those templates). The script will loop each file and add ".jpg" if it's missing or replace "jpg" with ".jpg".

Kris