Need help working with XML data from another data source.

[Brian Beckers]

What I need to do:
I need to have people fill out a form and send me the data, then I need to
be able to open the data and print it in a readable format. (sounds simple
right?)

Problem:
I have to work with a "fill in the blank" PDF form created in Acrobat 8 Pro,
which e-mails me the data in XML format. When I try to open the file in
Excel, I get the message "The specified XML source does not refer to a
schema." I click the OK, and get something very un-readable.

I have tried the option to "Use the XML Source task pane", and successfully
created a nice looking printable form this way. However, I don't want to have
to re-create this everytime I open up one of these XML formatted files that
get sent to me.

Am I missing something here?
Is there a better way to do what I need to acomplish?
Can I setup some kind of XML map that I can use to read these files as I get
them?

I'm starting to pull out my hair, and that's not good since there isn't much
left...

 

[Tim Williams]

Can you record a macro while openeing on of the files ?
Does that then work on other files ?

You could program using the MSXML components nd get at the data that way if
all else fails.

Tim