1. I have one file called "BrokerCommisions" and want to create a macro from here.
2. I have a file called "BRKCOMAPR09" - the first 6 characters will always be constant (the the latter 6 will change depending on the Month & Year). This file contains 5 worksheets.
Request # 1: From file listed in #1, I want to send only the first 2 worksheets (these are the first 2 - from left to right) of file listed in #2. The worksheets are called "Daily Details" and "DTD by Books" and want to only send these 2 worksheets as a file (let's call it "Daily Commissions") to a separate directory Path (lets call it I:\ABC\Commissions). The "Daily Commissions" file will be constant and should automatically be overwritten each time.
Request #2: If possible, can be part of macro for Request#1, once the "Daily Commissions" file is updated for the day, then automatically send an internal e-mail within the company to designated staff.
2. I have a file called "BRKCOMAPR09" - the first 6 characters will always be constant (the the latter 6 will change depending on the Month & Year). This file contains 5 worksheets.
Request # 1: From file listed in #1, I want to send only the first 2 worksheets (these are the first 2 - from left to right) of file listed in #2. The worksheets are called "Daily Details" and "DTD by Books" and want to only send these 2 worksheets as a file (let's call it "Daily Commissions") to a separate directory Path (lets call it I:\ABC\Commissions). The "Daily Commissions" file will be constant and should automatically be overwritten each time.
Request #2: If possible, can be part of macro for Request#1, once the "Daily Commissions" file is updated for the day, then automatically send an internal e-mail within the company to designated staff.