vba中如何根据ip读写网络其他主机中的共享文件
如题。已知ip、共享文件的目录。另外，在vba中使用vb的api函数有什么要求没有？谢谢！

[解决办法]

VB code

Private Type SHFILEOPSTRUCT     hwnd As Long     wFunc As Long     pFrom As String     pTo As String     fFlags As Long     fAnyOperationsAborted As Long     hNameMappings As Long     lpszProgressTitle As StringEnd TypePrivate Declare Function SHFileOperation Lib "shell32.dll" Alias "SHFileOperationA" (lpFileOp As SHFILEOPSTRUCT) As LongPrivate Sub Form_Load()    Dim result As Long, fileop As SHFILEOPSTRUCT    With fileop            .hwnd = Me.hwnd            .wFunc = FO_COPY            .pFrom = "C:\My Documents" & vbNullChar & vbNullChar            .pTo = "\\SQL\董博士\" & vbNullChar & vbNullChar            .fFlags = FOF_SILENT Or FOF_NOCONFIRMATION        result = SHFileOperation(fileop)    End WithEnd Sub