How can I open an Excel Workbook from an Outlook macro and activate that workbook? The goal is to enter a 4 digit number in an outlook userform (txtbox1), press a search button and the outlook macro should open an excel workbook (or if excel is already running, activate excel and open the specific workbook in a specific folder if it's not already opened, if the workbook is already opened, activate that workbook). Once the right workbook has been activated, go to sheet1 and search only from cell C11 to the last occupied cell in column C, if the number is found, retrieve the corresponding data in column A, B, C, D, E & F into the outlook userform txtbox2, txtbox3, txtbox4, txtbox5 & txtbox6. Close the workbook ONLY if the outlook macro opened it. Thanks!