Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Can I write VBA procedures that use Windows API calls and DLL calls – and are compatible with both Excel 5 and Excel 95?

April 26, 2017API compatible DLL Excel procedures VBA Windows write

0

Posted

Can I write VBA procedures that use Windows API calls and DLL calls – and are compatible with both Excel 5 and Excel 95?

1 Answer

0

Posted

Yes you can. You need to declare both API functions (using different names). You need to determine if the code is running in 16-bit Excel or 32-bit Excel and then call the appropriate API function.