dim a as string,b as string,c as string
a="C:\"
b="D:\"
c="1.txt"
怎么写就把c这个文件,从a移动到b
如果c在a里不存在,则msgbox "不存在?"
Excel vba 怎么移动一个文件?
答案:2 悬赏:50
解决时间 2021-02-19 15:45
- 提问者网友:紫柔同归
- 2021-02-18 22:56
最佳答案
- 二级知识专家网友:魅世女王
- 2021-02-18 23:52
Sub mysub()
Dim fso As Object
Dim a As String, b As String, c As String
a = "C:\"
b = "D:\"
c = "1.txt"
Set fso = CreateObject("Scripting.FileSystemObject")
If fso.FileExists(a & c) Then
fso.movefile a & c, b
Else
MsgBox "文件不存在"
End If
Set fso = Nothing
End Sub
Dim fso As Object
Dim a As String, b As String, c As String
a = "C:\"
b = "D:\"
c = "1.txt"
Set fso = CreateObject("Scripting.FileSystemObject")
If fso.FileExists(a & c) Then
fso.movefile a & c, b
Else
MsgBox "文件不存在"
End If
Set fso = Nothing
End Sub
全部回答
- 1楼网友:荒唐后生
- 2021-02-19 00:00
dim returnbyte() as byte
dim i as long
' 以二进制打开文件
open strfile for binary as #1
redim returnbyte(0 to lof(1) - 1) as byte
for i = 0 to lof(1) - 1
get #1, , returnbyte(i)
next i
' 关闭文件
close #1
一种方法,文件较大是比较耗内存哈,宜使用其它的技术去输入一个文件,比如一行一行地读取文件。
我要举报
如以上问答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息,可以点下面链接进行举报!
大家都在看
推荐资讯
• 手机登qq时,显示手机磁盘不足,清理后重新登 |
• 刺客的套装怎么选啊? |