Coded and working in Excel 2016 but not working in 2010.

[daithiboy]

Hi All,

I did up a simple userform based rig to record attendances at various meetings in a hospital. I did it all on my work laptop which runs excel 2016. It was working beautifully so I sent it to my boss to get the final go ahead, and what happened when he clicked one of the command buttons - RUN-TIME ERROR! Brilliant. Fabulous. Went back to my laptop and it works perfectly. I can't fathom it.

I work offsite and have no way of testing my code to figure out what is wrong as it is working on my computer.

Would any of you fine ladies & gentlemen be willing to run it in a different version to 2016 and give me some guidelines? I don't think I can upload a workbook here though?

Any help you can offer is, as always, greatly appreciated.

Thanks,
Dave

 

[daithiboy]

Check your references. One (or more) of them is not backwards compatible.

How might that be achieved??

 

[RoryA]

Which ones do you have checked? Tools - References in the VB Editor with your workbook project active

 

[daithiboy]

Which ones do you have checked? Tools - References in the VB Editor with your workbook project active

Thanks Rory! I'll see if I can crack it and update tomorrow.

Thanks gents.

 

[RoryA]

If you automate any other applications (eg Outlook or Word) using early binding, that code will not be backward compatible. You need to late bind so that you don't need the reference set.

 

[daithiboy]

If you automate any other applications (eg Outlook or Word) using early binding, that code will not be backward compatible. You need to late bind so that you don't need the reference set.

Right, you've lost me. Any chance you can you point me in the right direction of instructions on how to fix it?

 

[RoryA]

If you answer my question about which references are selected...

 

[daithiboy]

If you answer my question about which references are selected...

Ah...indeed

This is the lot

 

[RoryA]

Outlook is probably the issue. Are you actually automating it in your code?

 

[daithiboy]

Outlook is probably the issue. Are you actually automating it in your code?

I intend on using it in the project but it is not featured in this userform or code. I'll untick it and see how I get on tomorrow.

 

[RoryA]

You'll need to use late binding then if you have to support multiple Office versions.