By using expertatexcel.com you agree to our
cookie policy
, We and our partners operate globally and use cookies, for multiple purposes
Close
Become an
Σxpert at Σxcel.com
Home
Macro Intro
What can Excel do?
Learning >
Learning
Excel Books
Basic concepts
Immediate window
Macros 101
Syntax
Use existing code
Hello world
Math
formulas
Functions
Modifying Recorded Macros
Macro Recorder
Selecting
Moving data
Formatting
Clipboard
Range names
Filters
Sorting
Fill
Combining
Hyperlinks
Comments
Options
Vlookup
Conditional Formatting
Data validation
Pivot Tables
Charts
Charts
Macro Programming
Debugging
Strings
Active
This
vba statements
VBA functions
Run stuff
Object Model
Workbook
Sheet
Cells
Rows
Column
Range
Selection
Methods
Properties
Events
Collections
Chart
Software Dev
Variables
Data types
variables/scope
Conditionals
Loops
functions/sub
Arrays
testing
Batch
Software dev techniques
Backup/Recovery
Documentation
Wrappers
webservice
Refactor
Problems
#Errors
Problems
Too Slow/Optimize
Error handling
Problem Solving Method
Someone else's sheet
complex formula
Misc
Date/times
Code Generation
Random
Shortcuts
Forms
Special Chars
Customize your training
Work and learn
Projects/Apps
Reporting
Sample projects
Reconcliation
Adjusting data
Generate Slides
Special Characters
External
Outlook
Web
Database
Files
PPT
Word
API
Objects
Script host
Dos
Bloomberg
JIRA
Input Spreadsheets or files
Learning Tracks
Stocks
Bitcoin
Sports
Job
Productivity
Project Management
Tracking
Health
Games
Programmer
XML File format
I used VBA to generate XML output.
What is XML?
What did the code do?
Anything Special that it did?
A regulating authority required the output of a report in an XML format.
Steps:
Run query to create an Excel output for particular Legal Entity
Read the Excel file and formats it in an XML format
Open an Excel Template to go to regulator
Update the Template with the data
Save the file
Attach footnotes
Save the file and send in email to user