breader11
04-19-2013, 01:26 PM
Hello, VBA friends.
I'm looking for some VBA code that will do the following:
In my active workbook(Sheet1), I have ~ 10K email addresses in column #6, in column #23 I have either a 1 or a 0, and in column #24 I have a 0.
From this active workbook, I'd like to call a vba macro to open an Excel workbook titled "delivered.xlsx" that is located in the same folder as my active workbook. "delivered.xlsx" contains a single column of ~ 4K email addresses.
I'd like the VBA code to place a 1 in column #24 (active workbook) only when column #23 contains a 1 and an email match exists between #6 (active workbook) and #1(delivered.xlsx).
Finally, I'd like the VBA code to close "delivered.xlsx"
Thanks in advance for anyone who is able to help.
I'm looking for some VBA code that will do the following:
In my active workbook(Sheet1), I have ~ 10K email addresses in column #6, in column #23 I have either a 1 or a 0, and in column #24 I have a 0.
From this active workbook, I'd like to call a vba macro to open an Excel workbook titled "delivered.xlsx" that is located in the same folder as my active workbook. "delivered.xlsx" contains a single column of ~ 4K email addresses.
I'd like the VBA code to place a 1 in column #24 (active workbook) only when column #23 contains a 1 and an email match exists between #6 (active workbook) and #1(delivered.xlsx).
Finally, I'd like the VBA code to close "delivered.xlsx"
Thanks in advance for anyone who is able to help.