VBA Code for XSD using excel data

Jahnavi

New Member
Joined
Mar 8, 2019
Messages
1
Dears,

kindly help in writing VBA code to produce XSD for the below requirement. I have two columns one is having data element name and another column is defined hierarchy. Both columns are availble as excel data.

Schema DE NameHierarchy
NSM-VEHICLEPASSINFORMATIONNSM-VEHICLEPASSINFORMATION
gatePassNumberELEMENT(VEHICLEPASSINFORMATION)
gatePassGenerationDateTimeELEMENT(VEHICLEPASSINFORMATION)
gatePassStatusELEMENT(VEHICLEPASSINFORMATION)
tripTypeELEMENT(VEHICLEPASSINFORMATION)
totalTripsELEMENT(VEHICLEPASSINFORMATION)
entryCustomsStationCodeELEMENT(VEHICLEPASSINFORMATION)
exitCustomsStationCodeELEMENT(VEHICLEPASSINFORMATION)
transporterNameELEMENT(VEHICLEPASSINFORMATION)
transporterCodeELEMENT(VEHICLEPASSINFORMATION)
vehiclePlateNumberELEMENT(VEHICLEPASSINFORMATION)
driverNameELEMENT(VEHICLEPASSINFORMATION)
driverICELEMENT(VEHICLEPASSINFORMATION)
GATEPASSDETAILSCHILD(NSM-VEHICLEPASSINFORMATION)
GATEPASSDETAILCHILD(GATEPASSDETAILS)
tripNumberELEMENT(GATEPASSDETAIL)
tripStatusELEMENT(GATEPASSDETAIL)
ENTRYCHILD(GATEPASSDETAIL)
containerNumberELEMENT(ENTRY)
expectedEntryDateTimeELEMENT(ENTRY)
DECLARATIONSCHILD(ENTRY)
DECLARATIONCHILD(DECLARATIONS)
declarationNumberELEMENT(DECLARATION)
BLAWBNumberELEMENT(DECLARATION)
ITEMSCHILD(DECLARATION)
ITEMCHILD(ITEMS)
HSCodeELEMENT(ITEM)
quantityELEMENT(ITEM)
quantityUOMELEMENT(ITEM)
CONTAINERSCHILD(DECLARATION)
CONTAINERCHILD(CONTAINERS)
containerNumberELEMENT(CONTAINER)
EXITCHILD(GATEPASSDETAIL)
containerNumberELEMENT(EXIT)
expectedExitDateTimeELEMENT(EXIT)
DECLARATIONSCHILD(EXIT)
DECLARATIONCHILD(DECLARATIONS)
declarationNumberELEMENT(DECLARATION)
BLAWBNumberELEMENT(DECLARATION)
ITEMSCHILD(DECLARATION)
ITEMCHILD(ITEMS)
HSCodeELEMENT(ITEM)
quantityELEMENT(ITEM)
quantityUOMELEMENT(ITEM)
CONTAINERSCHILD(DECLARATION)
CONTAINERCHILD(CONTAINERS)
containerNumberELEMENT(CONTAINER)

<tbody>
</tbody>
 

Some videos you may like

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.

Watch MrExcel Video

Forum statistics

Threads
1,109,549
Messages
5,529,471
Members
409,884
Latest member
Msinmath
Top