Log In
Register
Home
September 26, 2018
Offline
Hi,
Could you please help me to solve kernel32 issue as I face it when I open attached macro.
Trusted Members
Moderators
November 1, 2018
Offline
Change the declarations section to:
#If VBA7 Then
Public Declare PtrSafe Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long)
Public Declare PtrSafe Function Beep Lib "kernel32" _
(ByVal dwFreq As Long, ByVal dwDuration As Long) As Long
#Else
Public Declare Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long)
Public Declare Function Beep Lib "kernel32" _
(ByVal dwFreq As Long, ByVal dwDuration As Long) As Long
#End If
Private ieBrowser As InternetExplorer
Note that the compiler will still highlight the bottom half in red but you can ignore that.
September 26, 2018
Offline
Thank you very much; your support is greatly appreciated.
I face other issue, can you check why I face "Timeout" status in column D
The target from this macro is open the URL "column B" then get the word from column C, and see if it is found in this URL or not then write the result in Column D.
Thanks;
Ehab
1 Guest(s)
