Excel problem - DLL not working

%3CLINGO-SUB%20id%3D%22lingo-sub-388958%22%20slang%3D%22en-US%22%3EExcel%20problem%20-%20DLL%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-388958%22%20slang%3D%22en-US%22%3E%3CP%3EGood%20afternoon%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESince%20I%20bought%20Office%20365%2C%20I%20must%20say%20I'm%20very%20happy%20with%20the%20product.%20But%20I'm%20having%20a%20problem%20regarding%20some%20Excel%20sheets%20I%20made%20(of%20astronomy)%20which%20used%20a%20personalized%20dll.%3C%2FP%3E%3CP%3EWhenever%20I%20try%20to%20run%20the%20application%2C%20I%20get%20that%20the%20code%20of%20the%20project%20must%20be%20updated%20to%20the%2064%20bits%20system%2C%20and%20that%20I%20must%20mark%20the%20Declare%20functions%20as%20PtrSafe.%20If%20I%20mark%20them%2C%20the%20error%20disappears%2C%20but%20the%20code%20doesn't%20run%2C%20like%20if%20didn't%20find%20the%20dll%2C%20or%20the%20dll%20was%20invalid.%3C%2FP%3E%3CP%3EAs%20far%20as%20I%20undertood%2C%20this%20is%20a%20very%20common%20problem%20in%20programmers%20that%20updated%20the%20Office%20to%20the%20365.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20can%20I%20fix%20this%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%20regards%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EJKepler%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-388958%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-388970%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20problem%20-%20DLL%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-388970%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F308463%22%20target%3D%22_blank%22%3E%40jkepler%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDid%20you%20check%20if%20the%20.dll%20is%20supported%20in%2032%20bit%20version...%20as%20per%20your%20description%20it%20seems%20that%20the%20.dll%20is%20only%20supported%20in%2064%20bit%20version%20and%20you%20are%20using%2032%20bit...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERobin%20Nishad%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Good afternoon

 

Since I bought Office 365, I must say I'm very happy with the product. But I'm having a problem regarding some Excel sheets I made (of astronomy) which used a personalized dll.

Whenever I try to run the application, I get that the code of the project must be updated to the 64 bits system, and that I must mark the Declare functions as PtrSafe. If I mark them, the error disappears, but the code doesn't run, like if didn't find the dll, or the dll was invalid.

As far as I undertood, this is a very common problem in programmers that updated the Office to the 365.

 

How can I fix this?

 

Best regards

 

JKepler

 

1 Reply
Highlighted

@jkepler 

 

Did you check if the .dll is supported in 32 bit version... as per your description it seems that the .dll is only supported in 64 bit version and you are using 32 bit...

 

Thanks

 

Robin Nishad