abdelfattah
04-09-2021, 01:48 PM
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
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