How to use wildcat* in the Macro

[PeterKem]

Hi,

I am trying to run the same macro for several Excel files with different file names. However, the same macro won't work because the excel file names are different. I have to change the names in the macro. Is there a way to use * as the file name in the Macro ?

FYI: My macro is to copy a name from one cell of column1 in the Excel, run a picture creating program, paste the picture onto column2 of the same row. After finishing the first excel file, I'd like to use the macro run the next excel file with different file name (different extension, such as, Microsoft Excel-1, -2, -3)


Thanks,

[forumsupport]

Hello PeterKem,

You can use the property of the macro that is available under General Properties and it is a checkbox that says 'Enable this macro to run with other similar files and window titles'. That will let you run the same macro on different Excel files with different names.

I just posted the answer to the other part of your question at
save results after N times macro run