Compatibility Problems between Versions

[dmazdes]

Hi,

This is a really weird one, I'm afraid. I built a data input template in Excel, using the Office365 version and saving it as an xlsm file. I emailed it to my colleagues for testing and approval before we send it out to our partners. It worked on most of their computers, although they had to click twice on the Export button that I put on the only visible sheet. But, that's a small problem.

The big problem is that one of my colleagues who works remotely uses her own brand new machine with what is probably Office 2019 installed on it. On her machine, the file opens in Developer mode! She is non-technical. She wouldn't even know how to make the Developer tab show up if she wanted to (which she doesn't). So, I sent a copy to my personal email so that I could try it on my personal PC, rather than my work laptop. I'm still using Office 2010 at home, but it did exactly the same thing: opened in Developer mode. Beyond just opening in Dev mode, it also displayed the ribbon and formula bar, both of which I had hidden in the original file.

So, on my home PC, in Office 2010, I hid the ribbon and formula bar again, put it back into normal mode, saved it, and sent it back to my work email. When I downloaded that version to my work laptop, it worked fine. I couldn't tell the difference. So, I sent it to my colleagues, again, for testing. And got exactly the same results. It mostly works on the other work laptops, which are not all the same but do run the same Office365, and doesn't work at all in the 2019 version.

So, I'm at a loss. I have absolutely no idea what to do about this. It might work on all machines if it was saved on an Office 2019 machine, but I don't have one, and the colleague who does wouldn't know how. Suggestions?

[rorya]

If you used an ActiveX button, replace it with a Form one (or a shape), and try again.

[dmazdes]

Thanks. That got us past the original problem and revealed an underlying problem, which is that the one non-work machine we've tried it on can't execute this line, even though it works on all the others;
Selection.Replace What:="""", Replacement:="", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False, FormulaVersion:=xlReplaceFormula2

[rorya]

Remove this part from the end:

Please Login or Register  to view this content.

[dmazdes]

Remove this part from the end:

Please Login or Register  to view this content.

Okay. Why?

[rorya]

Because that argument was added recently and doesn't exist in 2016 or earlier versions (I don't know about 2019).

[dmazdes]

Because that argument was added recently and doesn't exist in 2016 or earlier versions (I don't know about 2019).

Ahhh. Thanks!