These forums are now Read Only. If you have an Acrobat question, ask questions and get help from one of our experts.

Importing forms into Excel

2007-07-26 13:58:09

k_shaw

Registered: Jul 26 2007

Posts: 2

Hi there, I'm working in Adobe Professional 7.0 and Adobe Designer 7.0. I used Adobe Designer to make a form that i can send out; have people fill out and email back via a submit email button. When you open up the returned xml. document you should be able to open it up into an excel spreadsheet- when i do this, all the information comes up garbled... how do i make it so that the information imported into an excel spreadsheet actually represents what is on the form?

thx. kim

My Product Information:
Acrobat Pro 7.0.0, Windows

2007-08-23 12:17:23

thomp

Registered: Feb 15 2006

Posts: 4411

Not all XML files can automatically be loaded into Excel, it depends on the grammar of the file. I haven't done this with Excel before, but the typical way in which XML files are passed around is to provide the application with an XSLT translation file so it can translate your XML grammar into something that it understands. I do know that Excel has some built in tools for creating your own translation within Excel, but I've never used it.

Thom Parker
The source for PDF Scripting Info
www.pdfscripting.com
Very Important - How to Debug Your Script