Need Help - Dashboard Error (64 / 32 bit)

[Khalid NGO]

Hello everyone...

I have download some US Migration Dashboards, all of them are awesome.

I am receiving an error, and dont know what to do: (Suriya Banu Dashboard)



Any suggestion?

I am using win-XP and Office 2007.

Best Regards,

Khalid.

 

[Hui]

Khalid

Try inserting a ' infront of the Red line
ie: ' Private ...

 

[Khalid NGO]

Thanks Sir Hui,
I've tried but the result is same...



i have upload the file.

 

[shrivallabha]

Stab in the dark based on the message you are getting.

1. Remove the code from the sheet module completely.

2. And then in one of the inserted standard modules (or insert a new standard module using Insert|Module) put following:

'To give a time delay
' Source: http://www.exceltrick.com/formulas_macros/vba-wait-and-sleep-functions/
#If VBA7 Then
  Public Declare PtrSafe Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As LongPtr) 'For 64 Bit Systems
#Else
  Public Declare Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long) 'For 32 Bit Systems
#End If

And see if it resolves.

 

[NARAYANK991]

Hi Khalid ,

As far as I can see , the Sleep routine is not used anywhere in the file ; you can comment out all of the lines :

#If VBA7 Then
    Private Declare PtrSafe Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As LongPtr) 'For 64 Bit Systems
#Else
    Public Declare Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long) 'For 32 Bit Systems
#End If

Narayan

 

[Khalid NGO]

Thanks Sir Narayan and Shrivallabha,

I tried as you mentioned, but result is same:

 

[NARAYANK991]

Hi Khalid ,

The result is NOT the same !

The first error you posted has nothing to do with the error you are showing now.

It is possible that the Brightness property was added only in Excel 2010 , and if you are using Excel 2007 , you will get this error , there is nothing that can be done about it.

Narayan

 

[Hui]

Simply comment out the line

 

[Khalid NGO]

Hi Khalid ,

The result is NOT the same !

The first error you posted has nothing to do with the error you are showing now.

It is possible that the Brightness property was added only in Excel 2010 , and if you are using Excel 2007 , you will get this error , there is nothing that can be done about it.

Narayan

Simply comment out the line

Hello Narayan & Hui,
Yes you are right, result is not same. Actually i mentioned "result is same" coz the end result not worked for me.

As your and Hui's suggestion i tried to comment out those lines, now its working...
I've Enclosed the file:



Many thanks for cooperation and remain.
Khalid

 

[Hui]

Khalid

Great News

I was a Judge on that contest and I know I had a few small issues with getting it to work, but not as bad as you

I only use Excel 2010/13 and don't have access to 2007 to test

Hui...

 

[Khalid NGO]

Yes sir i knew,
i've download all files, its the only one which was not working....


Oh its working now
I am learning very new things here Daily