Hi,
I am new to VBA and trying to make a tedious task a bit easier. Hopefully someone can help me with this.
I have 3 different users in 3 different locations that handle my Outlook Calendar. They fill out appointments with customers, they also make an Excel file for that customer.
I have made some quick share form (enclosed image), that they fill relevant information, but not the macro button.
What I want to do, is to make their job a bit easier by making a macro in Outlook Calendar that does (by pressing a button):
1.
Opens a specific Excel Workbook in a shared location, but its not the same path on each computer. It is shared in a group area of Onedrive.
2.
Takes specific fields from the Outlook appointment and copies it to specific cells in the Excel Workbook. (image enclosed)
#1 Copy to cell B34
#2 Copy to cell B35
#3 Copy to cell B36
#4 Copy to cell B37
#5 Copy to cell B38, but only the date in format DD.MM.YY
3.
Runs a VBA (called: SvMe) in the open Excel Workbook and closes the workbook.
This will result in a Excel Workbook for that customer, that I will use later.
Hope someone can help me with this. It would save a whole lot of time for the girls in the departments.
Thank you
