Hi all,
I have an issue that just appeared when I upgraded a user to Windows 10 from Windows 7. We have a macro that uses an OLE process to transfer data from Excel to an ERP named Made2Manage. In Win7, this macro worked fine, but in Win 10 I get a Error 91 when the macro tries to load the OLE program. Here's how it works:
The user types in a sales order in Excel, then user selects "Save to Quote" which runs the macro which loads M2MOLE.exe, which opens up the connection so that the sales order can be uploaded to Made2Manage.
In my troubleshooting I confirmed a couple of things. If I run both Excel and Made2Manage as Administrator, this issue goes away. But as you know, running in admin mode limits my ability to load/save files as the actual user. If I try to set the m2mole.exe file to "Run as administrator" I get the 'this process requires elevation' error.
I'm sort of at my wit's end.
I have an issue that just appeared when I upgraded a user to Windows 10 from Windows 7. We have a macro that uses an OLE process to transfer data from Excel to an ERP named Made2Manage. In Win7, this macro worked fine, but in Win 10 I get a Error 91 when the macro tries to load the OLE program. Here's how it works:
The user types in a sales order in Excel, then user selects "Save to Quote" which runs the macro which loads M2MOLE.exe, which opens up the connection so that the sales order can be uploaded to Made2Manage.
In my troubleshooting I confirmed a couple of things. If I run both Excel and Made2Manage as Administrator, this issue goes away. But as you know, running in admin mode limits my ability to load/save files as the actual user. If I try to set the m2mole.exe file to "Run as administrator" I get the 'this process requires elevation' error.
I'm sort of at my wit's end.
