How to Automate Your Work with an Office Script Bot

How to Automate Your Work with an Office Script Bot

In this Office Script video I'm going to show you how to fully automate a common task. By using Power Automate we can allow Gmail and office script to interact with each other and many other applications. We are going to use these tools to recognise and email we receive, read inventory numbers from the email, get the correct data from a worksheet and finally reply to email with a pdf of the result. No human intervention required.

SUBSCRIBE TO THE CHANNEL: https://bit.ly/36hpTCY

DOWNLOAD THE WORKBOOK AND CODE: https://bit.ly/3wfz1Fl

Excel VBA Training
The Excel VBA Handbook Course(https://TheExcelVBAHandbook.com)
Webinar Archives - 60+ Hours of VBA training(https://excelmacromastery.com/excel-vba-webinars/)

Free Excel VBA Resources
Excel VBA Articles (https://excelmacromastery.com/vba-articles/)

Useful VBA Shortcut Keys
========================
Search keyword under cursor: Ctrl + F3
Search the word last searched for: F3
Compile the code: Alt + D + C OR Alt + D + Enter
Run the code from the current sub: F5
Step into the code line by line: F8
Add a breakpoint to pause the code: F9(or click left margin)
View the Immediate Window: Ctrl + G
View the Watch Window: Alt + V + H
Auto complete word: Ctrl + Space

Get the definition of the item under the cursor: Shift + F2
Go to the last cursor position: Ctrl + Shift + F2
Switch between Excel and the VBA Editor: Alt + F11
View the Project Explorer Window: Ctrl + R
Get the current region on a worksheet: Ctrl + Shift + 8(or Ctrl + *)
To move lines of code to the right(Indent): Tab
To move lines of code to the left(Outdent): Shift + Tab
Delete a Line: Ctrl + Y
View the Properties Window: F4