ExcelwolfAU
New Member
- Joined
- Feb 11, 2021
- Messages
- 3
- Office Version
- 365
- Platform
- Windows
Super frustrated
Ordinarily i would just do an XML export for this - but i cant because the software we are using uses a file format other than XML, and I really dont want to have to cut and paste or strip headers out of generated files.
So... I need to port over data from columns ("Location"), ("Model"), ("Manufacturer"), ("Address"), ("In Use"), ("Physical Form") into the following format:
<<Record 1>>
I would ideally like to do this as an excel VBA - but my VBA skills are junk - hopefully someone has some clever way to do this in the above format.
Cheers
Ordinarily i would just do an XML export for this - but i cant because the software we are using uses a file format other than XML, and I really dont want to have to cut and paste or strip headers out of generated files.
So... I need to port over data from columns ("Location"), ("Model"), ("Manufacturer"), ("Address"), ("In Use"), ("Physical Form") into the following format:
Code:
«Table» {
Location<"Location">
Model<"Model">
Manufacturer<"Manufacturer">
In_Use<"yes">
Address<"Address">
Physical_Form<"Physical Form">
}
{
Location<"Location">
Model<"Model">
Manufacturer<"Manufacturer">
In_Use<"yes">
Address<"Address">
Physical_Form<"Physical Form">
}
I would ideally like to do this as an excel VBA - but my VBA skills are junk - hopefully someone has some clever way to do this in the above format.
Cheers