How to keep open excel file and click macro buttion count the string in file


Hi All I have Few concers in my project:

  1. In a folder I have mulipul files in each file will having a comman keyword. If any file having the keyword morethen one time
    then need to get the same file names and number of times occred details into excel.
  2. How to keep open a specific excel file
  3. How to click macro Butttion in excel insted of alternative ways.
  4. While renaming files if any file name repeted then the repeted file name need to get in excel

For 2. Keep visible Mode checked when using Excel Scope

Use Execute Macro inside Excel scope to run the macro

1 Like

Hi Thanks for revert Now 1,2,3 is resolved

1 Like