Mithu Arora 7.Jul.11 02:53 AM a Web browser Applications Development6.5.1Windows XP
The following code will export the attachment names in the excel sheet.
Case "item"
Forall o In doc.Items
If ( o.Type = ATTACHMENT ) Then
attnames = attnames & "," & o.Values(0)
End If
End Forall
xFieldValue = attnames
Call ProcessFieldValue(excelSheet, ColumnLetter & Trim(Str(x)) , xFieldValue, Attachment)
If the document contains more than one attachment names then its output in excel sheet is displayed as ,test 1.xls, test2.xls.
I want the attachment names to be appeared in excel sheet as test1.xls, test2.xls. I want to remove the comma (') which appears before test 1.xls. Please let me know the resolution.