dopafreaks.blogg.se

1. #Excel vba on error does not work excel 2016 64 Bit
2. #Excel vba on error does not work excel 2016 windows 10

#Excel vba on error does not work excel 2016 windows 10

Sub Auto_open() 'Runs automatically when used directly from the Assai applicationĪs you can see I need this command line argument, which is working fine on Windows 7 for Excel 2016(32/64 bit) but on Windows 10 I do get a memory location address returned by "GetCommandLine" but in "CmdToStr" function returns "0" Thanks for your reply, please check below VBA codeĭeclare PtrSafe Function GetCommandLine Lib "kernel32" Alias "GetCommandLineW" () As Longĭeclare PtrSafe Function lstrlenW Lib "kernel32" (ByVal lpString As Long) As Longĭeclare PtrSafe Sub CopyMemory Lib "kernel32" Alias "RtlMoveMemory" (MyDest As Any, MySource As Any, ByVal MySize As Long)ĭeclare PtrSafe Function GetCommandLine Lib "kernel32" Alias "GetCommandLineA" () As Stringĭeclare PtrSafe Function lstrlenW Lib "kernel32" (ByVal lpString As Long) As LongPtrĭeclare PtrSafe Sub CopyMemory Lib "kernel32" Alias "RtlMoveMemory" (Destination As Any, Source As Any, ByVal Length As LongPtr) For any reply that either helps to answer your question or is the answer, please mark it as helpful or as the answer so others with the same question will

MainSleuth You've Got It, Use It! Engineering, Science, Statistics Solutions.

#Excel vba on error does not work excel 2016 64 Bit

I usually set declarations like the above in the appropriate conditional compiler statements when I expect the code to be run in unknown 32 / 64 bit environments: Might be that there's a permissions problem where the user doesn't have permissions in Win10, I also get return results for the 1st commands, but am not familiar with the 3rd (Memory maps/files? this article, Just pasting those lines in my Excel2016 / win10 machine did not create a problem when compiled in a Module (but it did of course for Class & the Excel Objects like ThisWorkbook because these expect to be explicitly declared Private - as usual). It would be helpful if we knew what the error is, and at least the place you have encountered it.