PDA

View Full Version : Forms in Excel


longarm
29th Aug 2007, 17:34
Does anybody know how I can import forms into excel so that they can be completed electronically. I know I can create a new form myself but what i want to do is insert a company form that already exists (pdf format) and then complete the fields rather than having to fill it in by hand.

swordfling
29th Aug 2007, 18:22
I don't think you can do that without effectively rebuilding the form in Excel. Adobe Acrobat Professional can create forms i.e. PDF forms that can be completed electronically using Adobe Acrobat Reader. Whoever created the PDFs you have may be able to convert them to PDF forms for you.

BOAC
29th Aug 2007, 18:26
Unless it involves spreadsheet calculations (?) set up a template in 'Word'?

swordfling
29th Aug 2007, 18:59
Good idea (just took some Syndol's - I think they're making me dopey!).

If you do have Acrobat Pro, it'll export the PDF to Word for you (though that can be a bit hit and miss in my experience). Otherwise, if you do have to start creating it again, Excel could be better if you want validation/pre-populating, or as BOAC says, calculations etc. There's also Microsoft InfoPath, but I don't really know anything about it.