Unable to run in Win 7 : help needed.

[chaitreya]

The excel enclosed was running perfect in win xp. However in win 7, it is not running. Can someone please help how to run it in win 7 ?

It need some swedll32 file to search ephemeris which is here:

http://www.4shared.com/file/Lq4O2jJoba/swedll32.html

[Sean Thomas]

Are you running windows 7 x32 or x64?

if you are running x64 then you will need to change your functions and declare them PTRsafe.

[chaitreya]

No, I am running 32 bit..

[Sean Thomas]

Can you provide some more information as to what is wrong? does it error?

[chaitreya]

error.png

yes,.... this type of error

[Sean Thomas]

sorry I cant read that. it just says Name: error.png

I don't think you have loaded it properly

[chaitreya]

Error msg:

"This workbook has lost its VBA project, ActiveX controls and any other programmability-related features."

[Sean Thomas]

I have just tried it on my windows 7 x32 pc, I didn't get the same error as you but you may need to change some references.
goto to VBA Editor Alt+F11
press the stop/reset button to stop the code debugger
goto tools, references
you should see the following screen which shows you have a reference missing to certain objects.
These differ from XP to Win7
try finding the nearest match

[chaitreya]

Thanks a lot. This error is resolved. But still the excel is not working...maybe due to the link to swedll32 (file to search ephemeris) ?