Dim filenames As Variant
Dim fn As Variant
Dim filename As String
filenames = Application.GetOpenFilename("Excel(*.xls),*.xls", 0, "Open a file", Null, True)
For Each fn In filenames
filename = CStr(fn)
...
Next如果在出现对话框的时候点取消就会出错,怎么解决阿,先谢谢了
Dim fn As Variant
Dim filename As String
filenames = Application.GetOpenFilename("Excel(*.xls),*.xls", 0, "Open a file", Null, True)
For Each fn In filenames
filename = CStr(fn)
...
Next如果在出现对话框的时候点取消就会出错,怎么解决阿,先谢谢了
解决方案 »
- picturebox 图片与窗体大小一致-100分
- 散点分,问些做VB外接程序的问题,各位做外接的大哥大姐来帮帮你可怜的小弟弟吧!!呜呜呜呜呜呜~~~~~~~~~~~
- 调用excel制作单据,在线等待!!!!
- VB6打的包在XP系统下安装不下,请帮忙
- 请问,怎样知道本机器共享目录名称(所有)
- vb窗口有好几个控件重叠放在一起,运行时能否返回在最顶层或最底层的控件
- 为何DATAREPORT中只放了一个LABEL, 但显示时由上到下出了很多个?
- 在vb中用swflash控件,为何不能播放"黄金矿工"等一些swf文件呢?
- format编译错误,请高手指点
- 关于COM+的问题
- 这样的SQL语句该怎么写
- 如何关闭网页的提示窗口(如网页内部产生的提示)?
if str(fn) & ""<>"" then
filename = Str(fn)
end if
...
Next
if str(fn) & ""<>"" then
filename = Str(fn)
end if
...
Next
Dim fn As Variant
Dim filename As String
filenames = Application.GetOpenFilename("Excel(*.xls),*.xls", 0, "Open a file", Null, True)
For Each fn In filenames
filename = CStr(fn)
MsgBox filename
Next
在Excel正常啊?
'判断在这里判断一下filename
if trim(filename) & ""<>"" then
For Each fn In filenames
filename = CStr(fn)
...
Next
end if
'判断在这里判断一下filename
if trim(filename) & ""<>"" then //选中文件时,trim(filenames) 类型不匹配
For Each fn In filenames
filename = CStr(fn)
...
Next
end if