Recent content by Tucker1050

Hi BD, I am in search of another macro to unhide and close & don't save all hidden workbooks except my "Personal (3).xlsb" workbook since it has all my macros. The code I found is below: Public Sub UnhideWorkbooks() Dim i As Integer For i = 1 To Workbooks.Count If...

AWESOME!! The file you attached BBD is exactly what I am looking for. Thank you and thank you SirJB7.

Thanks BBD!! I am really new to VBA. Could you provide me with the code and I could play around with it? Basically, I would be listing a series of text items in column A and if the search results are positive to display the path and filename in columns B and C respectively. It would be even...

Thanks for the info SirJB7. I am looking for the 2nd one that you are referencing. Do you have any software recommendations? If all else fails...I know what files to search, so I may just write a long look up formula.

Hello SirJB87. Thanks for the quick response. The items that I am referring to are words or phrases. To be more specific, I am working with SAP and have a list of document numbers ("100001321" for example). I want to see if "100001321" exists anywhere in the folder/sub-folder of multiple...

I am trying to search a directory at work (folders / sub-folders) for items listed in an excel workbook to see if those items are contained in any other excel file in the directory. Does anyone have a Macro that could do this? It would be great if the macro could return the path and file name...

I recently got upgraded to Excel 2010 and when I embed excel workbooks in other excel workbooks, they get thrown into the backgound as hidden. Is there a way to disable this feature?