Consulting

Results 1 to 3 of 3

Thread: search files across multiple sheets and open & highlight

  1. #1

    search files across multiple sheets and open & highlight

    hello
    I need macro search file across multiple sheets so I would that by inputbox first open inputbox ask me write the sheet then active the sheet and show another inputbox to write the file name based on active the sheet if there is existed then show message contains two choices if yes then open the file and highlight the file name is in located the cell and shows me another message where is address the cell and if it's not then nothing happens and when run again the input box then return any cell highlighted to xl none color and if I write wrong file name show me message the file is not existed
    note: my directory file is ": c:\users\ose\files\
    and when search in folder and subfolders
    Attached Files Attached Files
    Last edited by abdelfattah; 04-09-2021 at 02:28 PM.

  2. #2

  3. #3
    it's solved by Mr. dangelor anybody interests you can check the link

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •