Excel Macro to run on a specific title of a workbook

I have a macro that adds formulas and formatting. i need it to

1. run on a specific already opened workbook and worksheet with a specific name. the work book and worksheet both start with "XYZ%". the format of the file is CSV.
2. After the macro runs save it in text format in the same location.

thanks heaps.

Please take a few minutes to reread the forum rules about thread titles, and then amend yours accordingly.

Thanks.

Thank you.

Please Login or Register  to view this content.

Hello,

thanks but looks like the macro doesn't check other open workbooks with the same name. it does the first one and then closes it but doesn't go to the next one? also, if it can't find the workbook i can just put else exit sub?

... looks like the macro doesn't check other open workbooks with the same name. it does the first one and then closes it but doesn't go to the next one?

The code checks all open workbooks until it finds a workbook named like xyz%* that has a worksheet named like xyz*%.

also, if it can't find the workbook i can just put else exit sub?

You can, but that's what the code already does.