#1
|
|||
|
|||
Making a Outlook macro that opens a Excel Workbook
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 |
Tags |
excel 2016, outlook 2016, vba code |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Workbook Opens Slow from File Explorer | RetiredCHE | Excel | 0 | 08-18-2017 12:13 PM |
Macro Personal Workbook does not load in Excel 2016 | Intruder | Excel Programming | 0 | 01-21-2017 05:44 AM |
Hyperlink in excel opens email...can a macro fill in and insert attachments? | Tammypi | Outlook | 1 | 09-16-2014 10:36 PM |
Run Code when Workbook opens | gbaker | Excel Programming | 2 | 07-10-2012 10:41 AM |
the saveas macro in excel 2010 is not transferring the macros to the new workbook | missmr28 | Excel Programming | 3 | 06-20-2012 05:30 AM |