Damil4real
2011-01-24 17:06:04 UTC
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!
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!