Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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... |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Use detailed data in one worksheet to create summary data as chart source | Charts and Charting in Excel | |||
Setting hover data labels to cells other than source data | Charts and Charting in Excel | |||
Update a chart immediately after inputting data into data source | Charts and Charting in Excel | |||
Charts not recognizing source data if original linked data is changed. | Charts and Charting in Excel | |||
Pivot Table data source "data source contains no visible tables" | Excel Worksheet Functions |