347 Form Fields - need to selectively export to Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

parachutester@gmail.com - 27 Feb 2006 12:23 GMT

Hi, I have had to create an alimighty form with 347 form fields. There
was no way I could have reduced this number. I am trying to export
this data to Excel and have tried the Word->Tools->Options->Save forms
only route and then importing a comma delimited file to Excel. But
since the number of colums in Excel is 256, I am losing data. Is
there anyway I can be selective about exporting form fields to Excel?
If I could break up the form into two parts, I can then export it
twice. My Word file is broken up into sections, is there anyway I can
choose which sections get exported and which dont? Many thanks for all
help.

Reply to this Message

Doug Robbins - Word MVP - 27 Feb 2006 20:29 GMT

The following was created for another purpose, but by adding the
SaveFormsData:=True as I have, it maybe what you need.

Sub splitter()
' splitter Macro
' Macro created by Doug Robbins to save each letter created by a mailmerge
as a separate file.
Dim i As Long, Source As Document, Target As Document, Letter As Range
Set Source = ActiveDocument
For i = 1 To Source.Sections.Count
Set Letter = Source.Sections(i).Range
Letter.End = Letter.End - 1
Set Target = Documents.Add
Target.Range = Letter
Target.SaveAs FileName:="Letter" & i, SaveFormsData:=True
Target.Close
Next i
End Sub

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> Hi, I have had to create an alimighty form with 347 form fields. There
> was no way I could have reduced this number. I am trying to export
[quoted text clipped - 6 lines]
> choose which sections get exported and which dont? Many thanks for all
> help.

Reply to this Message

Parachute Woman - 02 Mar 2006 12:00 GMT

Many thanks, this solved my problem!

Reply to this Message