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.
40
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
€49.03
List Price:  €83.44
You save:  €34.40
£42.64
List Price:  £72.57
You save:  £29.92
CA$80.01
List Price:  CA$136.17
You save:  CA$56.15
A$87.39
List Price:  A$148.73
You save:  A$61.33
S$73.87
List Price:  S$125.71
You save:  S$51.84
HK$443.04
List Price:  HK$753.95
You save:  HK$310.91
CHF 45.63
List Price:  CHF 77.66
You save:  CHF 32.02
NOK kr575.03
List Price:  NOK kr978.56
You save:  NOK kr403.53
DKK kr366.20
List Price:  DKK kr623.18
You save:  DKK kr256.98
NZ$99.49
List Price:  NZ$169.32
You save:  NZ$69.82
د.إ209.33
List Price:  د.إ356.23
You save:  د.إ146.90
৳6,909.09
List Price:  ৳11,757.57
You save:  ৳4,848.48
₹5,016.66
List Price:  ₹8,537.13
You save:  ₹3,520.46
RM241.22
List Price:  RM410.50
You save:  RM169.28
₦83,054.13
List Price:  ₦141,337.73
You save:  ₦58,283.60
₨16,059.38
List Price:  ₨27,329.12
You save:  ₨11,269.74
฿1,855.29
List Price:  ฿3,157.25
You save:  ฿1,301.96
₺2,385.07
List Price:  ₺4,058.81
You save:  ₺1,673.74
B$312.69
List Price:  B$532.12
You save:  B$219.43
R986.28
List Price:  R1,678.41
You save:  R692.13
Лв95.81
List Price:  Лв163.04
You save:  Лв67.23
₩81,109.37
List Price:  ₩138,028.23
You save:  ₩56,918.85
₪187.66
List Price:  ₪319.36
You save:  ₪131.69
₱3,315.12
List Price:  ₱5,641.52
You save:  ₱2,326.40
¥8,627.43
List Price:  ¥14,681.76
You save:  ¥6,054.33
MX$1,051.67
List Price:  MX$1,789.68
You save:  MX$738.01
QR206.80
List Price:  QR351.93
You save:  QR145.12
P763.57
List Price:  P1,299.41
You save:  P535.84
KSh7,364.40
List Price:  KSh12,532.40
You save:  KSh5,168
E£2,716.55
List Price:  E£4,622.90
You save:  E£1,906.35
ብር8,382.73
List Price:  ብር14,265.36
You save:  ብር5,882.62
Kz51,982.74
List Price:  Kz88,461.86
You save:  Kz36,479.12
CLP$54,708.03
List Price:  CLP$93,099.63
You save:  CLP$38,391.60
CN¥406.21
List Price:  CN¥691.27
You save:  CN¥285.06
RD$3,589.17
List Price:  RD$6,107.89
You save:  RD$2,518.71
DA7,429.96
List Price:  DA12,643.98
You save:  DA5,214.01
FJ$129.54
List Price:  FJ$220.46
You save:  FJ$90.91
Q434.46
List Price:  Q739.35
You save:  Q304.88
GY$11,866.52
List Price:  GY$20,193.90
You save:  GY$8,327.38
ISK kr6,943.74
List Price:  ISK kr11,816.54
You save:  ISK kr4,872.80
DH521.46
List Price:  DH887.41
You save:  DH365.94
L964.14
List Price:  L1,640.73
You save:  L676.59
ден3,021
List Price:  ден5,141
You save:  ден2,120
MOP$454.20
List Price:  MOP$772.95
You save:  MOP$318.74
N$992.47
List Price:  N$1,688.94
You save:  N$696.47
C$2,087.37
List Price:  C$3,552.19
You save:  C$1,464.82
रु8,055.83
List Price:  रु13,709.04
You save:  रु5,653.21
S/194.25
List Price:  S/330.58
You save:  S/136.32
K242.02
List Price:  K411.86
You save:  K169.83
SAR213.77
List Price:  SAR363.79
You save:  SAR150.01
ZK1,280.40
List Price:  ZK2,178.93
You save:  ZK898.53
L249.52
List Price:  L424.62
You save:  L175.10
Kč1,190.16
List Price:  Kč2,025.36
You save:  Kč835.20
Ft19,150.26
List Price:  Ft32,589.05
You save:  Ft13,438.78
SEK kr540.70
List Price:  SEK kr920.14
You save:  SEK kr379.44
ARS$77,381.83
List Price:  ARS$131,684.87
You save:  ARS$54,303.04
Bs391.94
List Price:  Bs666.99
You save:  Bs275.04
COP$222,305.52
List Price:  COP$378,309.40
You save:  COP$156,003.88
₡28,541.85
List Price:  ₡48,571.23
You save:  ₡20,029.37
L1,489.34
List Price:  L2,534.49
You save:  L1,045.15
₲399,262.53
List Price:  ₲679,446.76
You save:  ₲280,184.23
$U2,285.39
List Price:  $U3,889.17
You save:  $U1,603.78
zł208.74
List Price:  zł355.23
You save:  zł146.49

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