Business Automation with VBA: Office Integration

Learn how to extend your Microsoft Excel VBA programs to integrate with MS-Word, MS-PowerPoint, send Outlook emails.

Business Automation with VBA: Office Integration

Learn how to extend your Microsoft Excel VBA programs to integrate with MS-Word, MS-PowerPoint, send Outlook emails.
42
views
Share the link to this page
Copied

About the Class

Extend your Microsoft Excel VBA programs

Integrate with MS-Word, MS-PowerPoint, send Outlook emails

Excel VBA Course with Mor Sagmon

What will you learn in this course?

  • You will be Competitive: do more than just automating Excel. Offer integration projects with other technologies and systems
  • You will be able to create impressive management reports: automate Word and PowerPoint reports based on your custom templates
  • You will be able to automate notification: Automate HTML-designed Email notifications from your application with attachments

Did you know you can

Create Word reports and Microsoft PowerPoint presentations, dynamically populated with Excel data. With Microsoft Excel VBA you can write a program that automatically creates impressive Office reports, such as a PowerPoint presentation populated with data you maintain in Microsoft Excel.

This is a management presentation you will create in the course from a Microsoft Excel table data.

Author

Mor Sagmon

Business Information Systems leader. Excel VBA Business Applications Expert
✔ World-class business software consultant ✔ Delivering Excel-based solutions for real life business challenges ✔ Serving customers such as Alstom, Tuttnauer, St. Croix Sensory, Hospitality Designs ✔ Developer of The Ultimate Excel Date Picker ✔ Author of the Computer Programming and Databases with Excel VBA and SQL online training program ✔...

School

Mor Sagmon's School

Requirements

You should have good VBA programming skills.

One-time Fee
$57
List Price:  $97
You save:  $40
€48.95
List Price:  €83.30
You save:  €34.35
£42.72
List Price:  £72.70
You save:  £29.98
CA$78.81
List Price:  CA$134.12
You save:  CA$55.31
A$85.81
List Price:  A$146.04
You save:  A$60.22
S$73.84
List Price:  S$125.66
You save:  S$51.82
HK$443.73
List Price:  HK$755.13
You save:  HK$311.39
CHF 45.82
List Price:  CHF 77.98
You save:  CHF 32.15
NOK kr576.08
List Price:  NOK kr980.35
You save:  NOK kr404.27
DKK kr365.64
List Price:  DKK kr622.24
You save:  DKK kr256.59
NZ$98.66
List Price:  NZ$167.90
You save:  NZ$69.24
د.إ209.33
List Price:  د.إ356.23
You save:  د.إ146.90
৳6,973.70
List Price:  ৳11,867.54
You save:  ৳4,893.83
₹5,126.89
List Price:  ₹8,724.71
You save:  ₹3,597.81
RM234.32
List Price:  RM398.76
You save:  RM164.44
₦82,696.98
List Price:  ₦140,729.95
You save:  ₦58,032.97
₨15,981.37
List Price:  ₨27,196.37
You save:  ₨11,215
฿1,813.53
List Price:  ฿3,086.19
You save:  ฿1,272.65
₺2,423.98
List Price:  ₺4,125.02
You save:  ₺1,701.04
B$310.04
List Price:  B$527.62
You save:  B$217.57
R964.79
List Price:  R1,641.85
You save:  R677.05
Лв95.76
List Price:  Лв162.96
You save:  Лв67.20
₩84,007.17
List Price:  ₩142,959.57
You save:  ₩58,952.40
₪184.42
List Price:  ₪313.84
You save:  ₪129.42
₱3,361
List Price:  ₱5,719.60
You save:  ₱2,358.60
¥8,855.52
List Price:  ¥15,069.92
You save:  ¥6,214.40
MX$1,035.95
List Price:  MX$1,762.93
You save:  MX$726.98
QR207.76
List Price:  QR353.56
You save:  QR145.79
P757.27
List Price:  P1,288.69
You save:  P531.42
KSh7,373.07
List Price:  KSh12,547.15
You save:  KSh5,174.08
E£2,711.49
List Price:  E£4,614.29
You save:  E£1,902.80
ብር8,841.13
List Price:  ብር15,045.43
You save:  ብር6,204.30
Kz52,269
List Price:  Kz88,949
You save:  Kz36,680
CLP$52,547.16
List Price:  CLP$89,422.36
You save:  CLP$36,875.20
CN¥402.99
List Price:  CN¥685.79
You save:  CN¥282.80
RD$3,630.13
List Price:  RD$6,177.59
You save:  RD$2,547.46
DA7,407.83
List Price:  DA12,606.31
You save:  DA5,198.48
FJ$128.84
List Price:  FJ$219.26
You save:  FJ$90.41
Q436.60
List Price:  Q743
You save:  Q306.39
GY$11,925.14
List Price:  GY$20,293.66
You save:  GY$8,368.52
ISK kr7,294.86
List Price:  ISK kr12,414.06
You save:  ISK kr5,119.20
DH526.45
List Price:  DH895.89
You save:  DH369.43
L969.82
List Price:  L1,650.41
You save:  L680.58
ден3,016.52
List Price:  ден5,133.38
You save:  ден2,116.85
MOP$457.07
List Price:  MOP$777.83
You save:  MOP$320.75
N$966.02
List Price:  N$1,643.94
You save:  N$677.91
C$2,097.64
List Price:  C$3,569.67
You save:  C$1,472.03
रु8,199.64
List Price:  रु13,953.78
You save:  रु5,754.13
S/191.59
List Price:  S/326.05
You save:  S/134.45
K241.87
List Price:  K411.60
You save:  K169.73
SAR213.91
List Price:  SAR364.03
You save:  SAR150.11
ZK1,312.52
List Price:  ZK2,233.59
You save:  ZK921.06
L249.23
List Price:  L424.14
You save:  L174.90
Kč1,184.65
List Price:  Kč2,015.99
You save:  Kč831.34
Ft18,697.14
List Price:  Ft31,817.94
You save:  Ft13,120.80
SEK kr535.82
List Price:  SEK kr911.84
You save:  SEK kr376.02
ARS$82,425.65
List Price:  ARS$140,268.22
You save:  ARS$57,842.56
Bs393.88
List Price:  Bs670.29
You save:  Bs276.40
COP$216,552.52
List Price:  COP$368,519.21
You save:  COP$151,966.68
₡27,842.93
List Price:  ₡47,381.83
You save:  ₡19,538.90
L1,501.23
List Price:  L2,554.74
You save:  L1,053.50
₲392,020.38
List Price:  ₲667,122.40
You save:  ₲275,102.02
$U2,229.29
List Price:  $U3,793.71
You save:  $U1,564.41
zł207.06
List Price:  zł352.36
You save:  zł145.30

What's Included

Language: English
Level: Intermediate
Skills: VBA, Word Documents, Microsoft PowerPoint, Business Automation, Excel, Office Integration, Microsoft
Age groups: All ages
Duration: 2 hours 22 minutes
10 Videos
4 Documents
1 Quiz
0
Saves
42
Views
This class has not been saved

Sign Up

Share

Share with friends, get 20% off
Invite your friends to LearnDesk learning marketplace. For each purchase they make, you get 20% off (upto $10) on your next purchase.