docmd.transferspreadsheet

[souris]

Does docmd.tracnsferspreadsheet has option to have overwrite warning
message?
Should I write I own code to verify the file exist?
If I should, which statement I can use?

Any information is great appreciated,


Souris,

 

[Douglas J. Steele]

Answers in-line below.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Does docmd.tracnsferspreadsheet has option to have overwrite warning
message?
No.

Should I write I own code to verify the file exist?

I always do.

If I should, which statement I can use?

If Len(Dir(strFileName)) > 0 Then
' strFileName exists: delete it
Kill strFileName
End If

 

[souris]

Thanks millions,

Souris,

Answers in-line below.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)





I always do.


If Len(Dir(strFileName)) > 0 Then
' strFileName exists: delete it
Kill strFileName
End If