Forum

Notifications
Clear all

kernel32 issue

5 Posts
2 Users
0 Reactions
134 Views
(@ehab1511)
Posts: 31
Trusted Member
Topic starter
 

Hi,

Could you please help me to solve kernel32 issue as I face it when I open attached macro.

issue.pngMY-PC.png

 
Posted : 02/05/2019 3:43 pm
(@debaser)
Posts: 837
Member Moderator
 

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.

 
Posted : 03/05/2019 4:48 am
(@ehab1511)
Posts: 31
Trusted Member
Topic starter
 

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

 
Posted : 03/05/2019 1:43 pm
(@debaser)
Posts: 837
Member Moderator
 

I'd guess it's taking longer than the 30s you specified for a timeout. I get Found when I run it.

 
Posted : 04/05/2019 9:58 am
(@ehab1511)
Posts: 31
Trusted Member
Topic starter
 

Grateful for your support..

 
Posted : 06/05/2019 4:55 pm
Share: