谢谢提醒,现将代码贴出: 模块一中的代码: '将字符串写入文件 Public Function writeStringToFile(sTargetString As String, sFileName As String) As String
Set fs = CreateObject("Scripting.FileSystemObject") Set fs_jb = fs.CreateTextFile(filepathname, True) fs_jb.writeline (sTargetString) fs_jb.Close writeFile = "写入文件成功!" End Function 按钮事件中的代码: Private Sub CommandButton_getTbsDefine_Click() Set sRtn = writeStringToFile("aaaa", "d:\test.sql") MsgBox sRtn, vbInformation, "提示"
End Sub
先解决你的“要求对象”的问题: 修改你的代码:'按钮事件中的代码: Private Sub CommandButton_getTbsDefine_Click() Dim sRtn$ sRtn = writeStringToFile("aaaa", "d:\test.sql") MsgBox sRtn, vbInformation, "提示" End Sub
模块一中的代码:
'将字符串写入文件
Public Function writeStringToFile(sTargetString As String, sFileName As String) As String
Set fs = CreateObject("Scripting.FileSystemObject")
Set fs_jb = fs.CreateTextFile(filepathname, True)
fs_jb.writeline (sTargetString)
fs_jb.Close
writeFile = "写入文件成功!"
End Function
按钮事件中的代码:
Private Sub CommandButton_getTbsDefine_Click()
Set sRtn = writeStringToFile("aaaa", "d:\test.sql")
MsgBox sRtn, vbInformation, "提示"
End Sub
Private Sub CommandButton_getTbsDefine_Click() Dim sRtn$
sRtn = writeStringToFile("aaaa", "d:\test.sql")
MsgBox sRtn, vbInformation, "提示" End Sub
这里面的:filepathname 与参数中的: sFileName 不一样,不知道是不是LZ写错了。
VBScript codeSet fs_jb = fs.CreateTextFile(filepathname, True)
再测试
VBScript codeSet
fs_jb = fs.CreateTextFile(filepathname, True)
第二个:你的Function中有个“变量”可能有误!
VBScript codeSet fs_jb = fs.CreateTextFile(filepathname, True)
这里面的:filepathname 与参数中的: sFileName 不一样,不知道是不是LZ写错了。
Set fs_jb = fs.CreateTextFile(filepathname, True)
SET fs_jb = fs.CreateTextFile(filepathname, True)