Hi VA, many thanks for looking into this, really appreciate it! I'll have a go at the changes you suggest and make sure it works on a 32bit machine too.
Let me know if you find any other issues.
VA
April 7th, 2014 at 10:48am
The change to be made is in module mdlWin32API - a PtrSafe keyword needs to be added between every Declare Function declaration. Example:
Before Change: Declare Function After Change: Declare PtrSafe Function
This is required for 64-bit Systems per Microsoft - Link - http://msdn.microsoft.com/en-us/library/office/gg251723%28v=office.15%29.aspx
I will test during the week for any other issues & update if any. Perhaps, you can make it conditional to adapt it to 32-bit or 64-bit upon invocation automatically.
Please let me know if you would like me to email you a modified version of the file.
Would you mind doing the debug compile on your machine please?
VA
April 4th, 2014 at 6:30pm
Recommendation is to 'Unprotect' the VBProject and do a Debug > Compile ... I believe the Macro is protected .. hence cannot debug! Thanks
VA
April 4th, 2014 at 6:26pm
Tried out the recommendation, but still get the same error. Please allow me to add more detail to the error received:
Compile error in hidden module: mdlWin32API: This error commonly occurs when code is incompatible with the version platform or architecture of this application. Click "Help" for information on how to correct this error.
"Help" takes you to the Excel website ...
Peter
April 2nd, 2014 at 11:09pm
Mmm, I don't have Windows 8 to test myself - would you mind checking a solution proposed here;
Any suggestions or overcome this error the error in the volatility spreadsheet - ' Compile error in hidden module: mdlWin32API error'. Thanks for your help.
VA
April 1st, 2014 at 8:47pm
The 'Compile error in hidden module: mdlWin32API error' when opening file in Office 2013 on Windows 8.1 occurs in the volatility spreadsheet. Thx
VA
April 1st, 2014 at 8:34pm
This in the volatility spreadsheet. Per this link http://answers.microsoft.com/en-us/office/forum/office_2010-excel/compile-error-in-hidden-module-win32api-windows-8/7507d274-8a46-4583-a8de-d7e12ac712ed, the issue seems to be related to API declarations made in a 32 bit but bein invoked in 64 bit (Windows 8.1) . Thanks for your help.
58 Comments
Peter April 8th, 2014 at 6:59am
Hi VA, many thanks for looking into this, really appreciate it! I'll have a go at the changes you suggest and make sure it works on a 32bit machine too.
Let me know if you find any other issues.
VA April 7th, 2014 at 10:48am
The change to be made is in module mdlWin32API - a PtrSafe keyword needs to be added between every Declare Function declaration. Example:
Before Change: Declare Function
After Change: Declare PtrSafe Function
This is required for 64-bit Systems per Microsoft - Link - http://msdn.microsoft.com/en-us/library/office/gg251723%28v=office.15%29.aspx
I will test during the week for any other issues & update if any. Perhaps, you can make it conditional to adapt it to 32-bit or 64-bit upon invocation automatically.
Please let me know if you would like me to email you a modified version of the file.
Many thanks for your help.
Peter April 7th, 2014 at 6:48am
Oh right, here is the unlocked version;
Historical Volatility No Password
Would you mind doing the debug compile on your machine please?
VA April 4th, 2014 at 6:30pm
Recommendation is to 'Unprotect' the VBProject and do a Debug > Compile ...
I believe the Macro is protected .. hence cannot debug! Thanks
VA April 4th, 2014 at 6:26pm
Tried out the recommendation, but still get the same error. Please allow me to add more detail to the error received:
Compile error in hidden module: mdlWin32API: This error commonly occurs when code is incompatible with the version platform or architecture of this application. Click "Help" for information on how to correct this error.
"Help" takes you to the Excel website ...
Peter April 2nd, 2014 at 11:09pm
Mmm, I don't have Windows 8 to test myself - would you mind checking a solution proposed here;
Compile error in hidden module.
VA April 2nd, 2014 at 9:43pm
Any suggestions or overcome this error the error in the volatility spreadsheet - ' Compile error in hidden module: mdlWin32API error'. Thanks for your help.
VA April 1st, 2014 at 8:47pm
The 'Compile error in hidden module: mdlWin32API error' when opening file in Office 2013 on Windows 8.1 occurs in the volatility spreadsheet. Thx
VA April 1st, 2014 at 8:34pm
This in the volatility spreadsheet. Per this link http://answers.microsoft.com/en-us/office/forum/office_2010-excel/compile-error-in-hidden-module-win32api-windows-8/7507d274-8a46-4583-a8de-d7e12ac712ed, the issue seems to be related to API declarations made in a 32 bit but bein invoked in 64 bit (Windows 8.1) . Thanks for your help.
Peter April 1st, 2014 at 12:35am
Is this the pricing or volatility spreadsheet?
Add a Comment