Trevor3007
Well-known Member
- Joined
- Jan 26, 2017
- Messages
- 667
- Office Version
- 365
- Platform
- Windows
hello,
i have to send a workbook to a 3rd party when there have been any changes to the workbook. the location is always the same as is part of the the file name
(IE :\3rdparty\testAs_At-01-12-2018 22-34-29
must include the date & time of report for reference purpose ( date\time format is dd-mm-yyyy hh-mm-ss and using the =now formula) which is in cell B1
The report that gets emailed using a pre-defined outlook.oft file.
Does anyone have the VB knowledge to save the file as described and email the attached file to the applicable *.oft file.
MTIA & hope someone can do this.
KR
Trevor3007
i have to send a workbook to a 3rd party when there have been any changes to the workbook. the location is always the same as is part of the the file name
(IE :\3rdparty\testAs_At-01-12-2018 22-34-29
must include the date & time of report for reference purpose ( date\time format is dd-mm-yyyy hh-mm-ss and using the =now formula) which is in cell B1
The report that gets emailed using a pre-defined outlook.oft file.
Does anyone have the VB knowledge to save the file as described and email the attached file to the applicable *.oft file.
MTIA & hope someone can do this.
KR
Trevor3007