Business Automation with VBA: Working with Files

Learn how to extend your Microsoft Excel VBA programs to interface with other applications, exchange data and access files and folders.
00:00
00:00

Business Automation with VBA: Working with Files

Learn how to extend your Microsoft Excel VBA programs to interface with other applications, exchange data and access files and folders.
34
views
Share the link to this page
Copied

About the Class

Extend your Microsoft Excel VBA programs

Integrate with other applications, export/import data, create PDF reports.

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 automate integration with other applications: two VBA techniques for importing and exporting files are demonstrated
  • You will be able to create slick PDF reports: Dynamically generate a PDF file from your Excel data and charts for printing, sending or archiving

With Excel VBA you can create a slick PDF report, with beautiful Excel charts and data, and even automatically send it as an attachment by email.

This is a PDF training certificate you will create in the course.Excel VBA PDF File

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
€50.74
List Price:  €86.35
You save:  €35.60
£42.69
List Price:  £72.66
You save:  £29.96
CA$79.39
List Price:  CA$135.10
You save:  CA$55.71
A$87.99
List Price:  A$149.74
You save:  A$61.75
S$73.92
List Price:  S$125.79
You save:  S$51.87
HK$444.82
List Price:  HK$756.98
You save:  HK$312.15
CHF 47.58
List Price:  CHF 80.98
You save:  CHF 33.39
NOK kr586.56
List Price:  NOK kr998.18
You save:  NOK kr411.62
DKK kr378.49
List Price:  DKK kr644.10
You save:  DKK kr265.61
NZ$95.72
List Price:  NZ$162.89
You save:  NZ$67.17
د.إ209.36
List Price:  د.إ356.28
You save:  د.إ146.92
৳6,912.14
List Price:  ৳11,762.76
You save:  ৳4,850.62
₹4,861.16
List Price:  ₹8,272.50
You save:  ₹3,411.34
RM245.24
List Price:  RM417.35
You save:  RM172.10
₦91,361.31
List Price:  ₦155,474.51
You save:  ₦64,113.20
₨16,015.36
List Price:  ₨27,254.21
You save:  ₨11,238.85
฿1,891.83
List Price:  ฿3,219.43
You save:  ฿1,327.60
₺2,209.94
List Price:  ₺3,760.79
You save:  ₺1,550.84
B$320.35
List Price:  B$545.15
You save:  B$224.80
R1,038.91
List Price:  R1,767.97
You save:  R729.06
Лв99.24
List Price:  Лв168.88
You save:  Лв69.64
₩79,486.51
List Price:  ₩135,266.52
You save:  ₩55,780.01
₪202.88
List Price:  ₪345.25
You save:  ₪142.37
₱3,182.08
List Price:  ₱5,415.12
You save:  ₱2,233.04
¥8,315.10
List Price:  ¥14,150.26
You save:  ¥5,835.16
MX$1,103.32
List Price:  MX$1,877.59
You save:  MX$774.26
QR207.59
List Price:  QR353.26
You save:  QR145.67
P776.67
List Price:  P1,321.70
You save:  P545.03
KSh7,368.59
List Price:  KSh12,539.54
You save:  KSh5,170.94
E£2,871.91
List Price:  E£4,887.29
You save:  E£2,015.38
ብር7,612.68
List Price:  ብር12,954.91
You save:  ብር5,342.23
Kz52,240.50
List Price:  Kz88,900.50
You save:  Kz36,660
CLP$53,604.51
List Price:  CLP$91,221.71
You save:  CLP$37,617.20
CN¥410.58
List Price:  CN¥698.72
You save:  CN¥288.13
RD$3,349.86
List Price:  RD$5,700.64
You save:  RD$2,350.78
DA7,619.82
List Price:  DA12,967.06
You save:  DA5,347.24
FJ$131.37
List Price:  FJ$223.56
You save:  FJ$92.19
Q437.58
List Price:  Q744.65
You save:  Q307.07
GY$11,903.37
List Price:  GY$20,256.62
You save:  GY$8,353.24
ISK kr7,361.55
List Price:  ISK kr12,527.55
You save:  ISK kr5,166
DH532.15
List Price:  DH905.58
You save:  DH373.43
L982.30
List Price:  L1,671.63
You save:  L689.33
ден3,156.86
List Price:  ден5,372.20
You save:  ден2,215.34
MOP$456.63
List Price:  MOP$777.08
You save:  MOP$320.44
N$1,042.86
List Price:  N$1,774.70
You save:  N$731.83
C$2,094.30
List Price:  C$3,563.99
You save:  C$1,469.69
रु7,732.42
List Price:  रु13,158.69
You save:  रु5,426.26
S/207.82
List Price:  S/353.66
You save:  S/145.84
K234.08
List Price:  K398.35
You save:  K164.26
SAR213.79
List Price:  SAR363.81
You save:  SAR150.02
ZK1,497.94
List Price:  ZK2,549.13
You save:  ZK1,051.18
L259.02
List Price:  L440.79
You save:  L181.77
Kč1,264.26
List Price:  Kč2,151.46
You save:  Kč887.20
Ft20,501.29
List Price:  Ft34,888.16
You save:  Ft14,386.87
SEK kr550.88
List Price:  SEK kr937.46
You save:  SEK kr386.58
ARS$64,125.86
List Price:  ARS$109,126.46
You save:  ARS$45,000.60
Bs394.55
List Price:  Bs671.42
You save:  Bs276.87
COP$237,948.38
List Price:  COP$404,929.70
You save:  COP$166,981.32
₡28,893.84
List Price:  ₡49,170.23
You save:  ₡20,276.38
L1,473.45
List Price:  L2,507.45
You save:  L1,034
₲454,566.56
List Price:  ₲773,560.64
You save:  ₲318,994.08
$U2,381.30
List Price:  $U4,052.39
You save:  $U1,671.08
zł215.43
List Price:  zł366.61
You save:  zł151.18

What's Included

Language: English
Level: Intermediate
Skills: VBA, PDF Reports, Microsoft Excel, Excel VBA, Business Automation, Exchange Data, Excel Charts
Age groups: All ages
Duration: 3 hours 56 minutes
11 Videos
3 Documents
1 Quiz
0
Saves
34
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.