假定c盘下有一EXCEL文件a.xls,并已经打开,应该用什么语句来判断文件是否已经打开呢?请各位大虾指教。
解决方案 »
- <p color=red>红色标题 2楼接分</p>
- 急,在线等!如何可以使ListBox可以多列显示!
- vb6的SpinButton在哪个部件里面?
- VB菜鸟所以个问题
- 新手提问,说是提问其实就是帮忙做题,呵呵,谢谢(百分伺候)
- 如何把一个MDI窗体的子窗体卸载掉--急!在线等待!!问题解决即结帖
- 串口接收数据处理
- 请问:哪里可以下载VSFlexGrid pro8 以及它的注册码?
- 套打问题,急!
- 用installshield打得包,程序在win2000,Xp运行正常,但在NT4上运行错误,(-2147417848(80010108))
- 如何将EXCEL格的指定格的数据导入SQL 2000中?(需原代码)
- 请大虾看看我对于两个控件值的判断语句有何问题?
Const OF_SHARE_DENY_READ = &H30Private Type OFSTRUCT
cBytes As Byte
fFixedDisk As Byte
nErrCode As Integer
Reserved1 As Integer
Reserved2 As Integer
szPathName(OFS_MAXPATHNAME) As Byte
End TypePrivate Declare Function CloseHandle Lib "kernel32" (ByVal hObject As Long) As Long
Private Declare Function OpenFile Lib "kernel32" (ByVal lpFileName As String, lpReOpenBuff As OFSTRUCT, ByVal wStyle As Long) As Long
Private OF As OFSTRUCT
Private Sub Form_Load()
Dim hFile As Long
hFile = OpenFile("c:\a.xls", OF, OF_SHARE_DENY_READ)
If hFile = -1 Then
If Err.LastDllError = 32 Then
MsgBox "文件已打开"
Else
MsgBox "异常错误:" & Err.LastDllError
End If
Else
MsgBox "文件未打开"
CloseHandle hFile
End IfEnd Sub