Need help working with XML data from another data source.
 

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...

Need help working with XML data from another data source.
 

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

"Brian Beckers" wrote in message
...
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...