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.
39
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.78
List Price:  €83.01
You save:  €34.23
£42.91
List Price:  £73.02
You save:  £30.11
CA$78.38
List Price:  CA$133.38
You save:  CA$55
A$87.18
List Price:  A$148.36
You save:  A$61.18
S$73.18
List Price:  S$124.54
You save:  S$51.36
HK$444.46
List Price:  HK$756.37
You save:  HK$311.90
CHF 46.39
List Price:  CHF 78.94
You save:  CHF 32.55
NOK kr573.35
List Price:  NOK kr975.70
You save:  NOK kr402.35
DKK kr364.09
List Price:  DKK kr619.60
You save:  DKK kr255.50
NZ$96.74
List Price:  NZ$164.64
You save:  NZ$67.89
د.إ209.33
List Price:  د.إ356.23
You save:  د.إ146.90
৳6,919.98
List Price:  ৳11,776.11
You save:  ৳4,856.12
₹5,025.54
List Price:  ₹8,552.24
You save:  ₹3,526.69
RM240.82
List Price:  RM409.82
You save:  RM169
₦87,322.55
List Price:  ₦148,601.54
You save:  ₦61,278.98
₨16,144.42
List Price:  ₨27,473.84
You save:  ₨11,329.41
฿1,844.28
List Price:  ฿3,138.52
You save:  ฿1,294.23
₺2,342.70
List Price:  ₺3,986.70
You save:  ₺1,644
B$309.58
List Price:  B$526.84
You save:  B$217.25
R1,006.22
List Price:  R1,712.34
You save:  R706.12
Лв95.31
List Price:  Лв162.21
You save:  Лв66.89
₩79,171.29
List Price:  ₩134,730.09
You save:  ₩55,558.80
₪189.96
List Price:  ₪323.27
You save:  ₪133.30
₱3,254.01
List Price:  ₱5,537.53
You save:  ₱2,283.52
¥8,380.99
List Price:  ¥14,262.39
You save:  ¥5,881.40
MX$1,063.34
List Price:  MX$1,809.54
You save:  MX$746.20
QR207.41
List Price:  QR352.96
You save:  QR145.55
P766.12
List Price:  P1,303.76
You save:  P537.63
KSh7,352.08
List Price:  KSh12,511.44
You save:  KSh5,159.35
E£2,734.04
List Price:  E£4,652.67
You save:  E£1,918.63
ብር8,104.55
List Price:  ብር13,791.95
You save:  ብር5,687.40
Kz52,269
List Price:  Kz88,949
You save:  Kz36,680
CLP$55,072.11
List Price:  CLP$93,719.22
You save:  CLP$38,647.10
CN¥406.45
List Price:  CN¥691.68
You save:  CN¥285.23
RD$3,583.62
List Price:  RD$6,098.44
You save:  RD$2,514.82
DA7,395.29
List Price:  DA12,584.97
You save:  DA5,189.68
FJ$128.55
List Price:  FJ$218.77
You save:  FJ$90.21
Q436.19
List Price:  Q742.30
You save:  Q306.10
GY$11,900.86
List Price:  GY$20,252.35
You save:  GY$8,351.48
ISK kr6,974.11
List Price:  ISK kr11,868.23
You save:  ISK kr4,894.11
DH513.01
List Price:  DH873.02
You save:  DH360.01
L948.08
List Price:  L1,613.41
You save:  L665.32
ден3,001.06
List Price:  ден5,107.07
You save:  ден2,106.01
MOP$456.92
List Price:  MOP$777.57
You save:  MOP$320.65
N$1,010.15
List Price:  N$1,719.04
You save:  N$708.88
C$2,094.18
List Price:  C$3,563.79
You save:  C$1,469.60
रु8,025.35
List Price:  रु13,657.18
You save:  रु5,631.82
S/201.41
List Price:  S/342.75
You save:  S/141.34
K240.82
List Price:  K409.82
You save:  K169
SAR213.88
List Price:  SAR363.98
You save:  SAR150.09
ZK1,342.15
List Price:  ZK2,284.01
You save:  ZK941.86
L247.49
List Price:  L421.17
You save:  L173.68
Kč1,192.93
List Price:  Kč2,030.07
You save:  Kč837.14
Ft19,366.58
List Price:  Ft32,957.17
You save:  Ft13,590.58
SEK kr539.31
List Price:  SEK kr917.77
You save:  SEK kr378.46
ARS$75,914.49
List Price:  ARS$129,187.82
You save:  ARS$53,273.32
Bs393.23
List Price:  Bs669.18
You save:  Bs275.95
COP$229,224.12
List Price:  COP$390,083.16
You save:  COP$160,859.03
₡28,735.33
List Price:  ₡48,900.47
You save:  ₡20,165.14
L1,489.97
List Price:  L2,535.56
You save:  L1,045.59
₲411,425.71
List Price:  ₲700,145.52
You save:  ₲288,719.80
$U2,280.35
List Price:  $U3,880.59
You save:  $U1,600.24
zł207.98
List Price:  zł353.94
You save:  zł145.95

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
39
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.