- ©«¤l
- 5923
- ¥DÃD
- 13
- ºëµØ
- 1
- ¿n¤À
- 5986
- ÂI¦W
- 0
- §@·~¨t²Î
- win10
- ³nÅ骩¥»
- Office 2010
- ¾\ŪÅv
- 150
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥xÆW°ò¶©
- µù¥U®É¶¡
- 2010-5-1
- ³Ì«áµn¿ý
- 2022-1-23
|
¦^´_ 1# smart3135
¤W¶ÇªþÀÉ ¥ÎÂX®i¦W: chm, pdf, zip, rar, tar, gz, bzip2, gif, jpg, jpeg, png- Option Explicit
- Sub Ex1()
- Dim IE As Object
- Dim Rng As Range, UrL As String, R As Range, j
- Set IE = CreateObject("InternetExplorer.Application")
- With Sheets(2)
- Set Rng = .Range("A1", .Range("A65535").End(xlUp))
- End With
- For Each R In Rng
- UrL = "C:\FujiFlexa\Client\Report\Jobdata\job00" & j & R
- If Dir(UrL) = "" Then 'Àˬd¤£¨ìÀÉ®×
- If MsgBox("§ä¤£¨ì " & UrL & vbLf & "¬O(Y):Ä~Äò¤U¤@Óºô¶" & vbLf & "§_(N):µ²§ôµ{¦¡", vbYesNo) = vbYes Then
- GoTo AG1
- Else
- IE.Quit
- Exit Sub
- End If
- End If
- With IE
- .Navigate UrL
- Do While .Busy Or .readyState <> 4: DoEvents: Loop
- '**************
- 'µ{¦¡½X********
- '**************
- End With
- AG1:
- Next
- IE.Quit
- End Sub
½Æ»s¥N½X |
|