EXCEL MACRO (compatibility problem between MS office2007 and 2016)
A freelancer developped severals macro on an excel file (on a server using Windows server 2012 r2 64bit and microsoft office 2007). This file is done to be connected to a software that constantly feeds some cells (macros are there to analyse those datas sent by the software).
All macros were working well without any problems.
I changed my configuration and now I am using Windows server 2012 r2 64bit but microsoft office 2016. Now I cannot connect anymore the excel file to the software because the excel file is always being closed as soon as macros are activated by the software. Here are details of what excel tells about closure reasons :
Problem Event Name: APPCRASH
Application Name: [url removed, login to view]
Application Version: 16.0.8201.2213
Application Timestamp: 5a226d3f
Fault Module Name: [url removed, login to view]
Fault Module Version: 16.0.8201.2213
Fault Module Timestamp: 5a226d3f
Exception Code: c0000005
Exception Offset: 0000000000ef2f3f
OS Version: 6.3.[url removed, login to view]
Locale ID: 1036
Additional Information 1: 365f
Additional Information 2: 365f95e25ec89055619ddddea0ad65b5
Additional Information 3: a953
Additional Information 4: a95330f1947466d1d53a12576272d4a1
Read our privacy statement online:
[url removed, login to view]
If the online privacy statement is not available, please read our privacy statement offline:
C:\windows\system32\en-US\[url removed, login to view]
Here is attached the excel file that is closed when software activates macros.
What I need is a freelancer ready to resolve that problem, using teamviewer to access my computer in live. At the end I want all macros to be working well when the excel file is connected to the software.
** Note **
I prefer to work with Freelancers who only work for themselves and their clients. Like that we can communicate all the day and it is also a way for me to be sure that the job is done fastly and carefully.
** Thank you for your comprehension **
Hi, What I propose is, I will first understand the macro and all the excel file content that copy have. Then I will recreate it in 2016 by copy paste. Recently deliverd a Excel VBA project.