troubleshooting Question

Need VBA code to save file as XML with specific name

Avatar of CRGman
CRGmanFlag for United States of America asked on
Microsoft OfficeMicrosoft AccessMicrosoft Applications
12 Comments5 Solutions655 ViewsLast Modified:
I am working on a database that creates an XML file for every record that is updated in a table.   The file name of the record must be named the value of one of the field names.  

This record is created to contain descriptive data about an image file that is created outside the database but the name of the image file is populated into the record that is being updated and this name is what the file name for the record being updated in the Access database needs to be named.  

Can anyone help me out with the code to:
1.   Save a file as XLM for a specific record
2.   Name a file using the value of a field name in a specific record


Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 5 Answers and 12 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 5 Answers and 12 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros