请教高手:如何用VBA连接远程电脑某个目录下的txt文件??譬如远程某个IP的D盘下的文本文件如何读取?请给个链接或者例子提点一下,谢谢~~~~
用FSO方法调试时提示文件名错误Set f = fs.OpenTextFile("http\\10.86.35.28\D:\test.txt", 1, TristateFalse)
用FSO方法调试时提示文件名错误Set f = fs.OpenTextFile("http\\10.86.35.28\D:\test.txt", 1, TristateFalse)
\\10.86.35.28\d$\test.txt
UserName = "somedomain\someuser"
Password = "somepassword"Set NetworkObject = CreateObject("WScript.Network")NetworkObject.MapNetworkDrive "", ServerShare, False, UserName, PasswordSet FSO = CreateObject("Scripting.FileSystemObject")
Set Directory = FSO.GetFolder(ServerShare)
For Each FileName In Directory.Files
WScript.Echo FileName.Name
Next
Set FileName = Nothing
Set Directory = Nothing
Set FSO = NothingNetworkObject.RemoveNetworkDrive ServerShare, True, FalseSet NetworkObject = Nothing