Hi there!
I have an agent to export documents to an excel sheet and a word doc.
This same agent create 2 folders in the directory C://. One contains all file’s documents and other contains all documents exported to .doc
This agent ran perfectly about 3 months but now I got the error “path/file acess error” when document in position 236 in excel spreadsheet.And I get the error always in this position… And the debug show the error when create the directory on C://
Here’s the part of the code that I use for export.
Set item = doc.GetFirstItem(“Body”)
If ( item.Type = RICHTEXT ) Then
If Not Isempty(item.EmbeddedObjects) Then
Forall o In item.EmbeddedObjects
If(o.Type = EMBED_ATTACHMENT) Then
If xlApp.cells(linha,18).value = "" Then
caminho = "C:\SISPAT (Anexos)\" & doc.CodPad(0) & " - Rev " & Cstr(doc.UltRev(0)) & " (Anexos)\"
Mkdir caminho
xlApp.cells(linha,18).value = caminho
End If
nome = o.Source
Call o.ExtractFile(caminho & nome)
End If
End Forall
End If
End If
Could you help me to solve this pluzze?
Thanks in advance.