Thread: [Solved] Save Form Data as Delimited text via VBA
View Single Post
 
Old 10-06-2017, 03:35 AM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
Is there a reason for not using the same Save method to save the form data instead of just saving the document as a text file?
Code:
With ActiveDocument
  .SaveAs2 FileName:=Split(.FullName, ".")(0) & "_Form.csv", _
    Fileformat:=wdFormatText, SaveFormsData:=True
End With
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote