Is it possible to emulate Excel 2010 from Office 365?

[wpryan]

I learned recently that some people in my company are holdouts with Office - some are still on Office 2010, and some are incredibly still using Windows 7. Sometimes the code I write doesn't work on these computers. Is it possible to check for this beforehand? Do I have to install an earlier version of Excel, or can I somehow emulate Excel 2010 from Excel 365? If I have to install an earlier version, how to do it?

 

[JEC]

If your are not using worksheetfunctions in your code you should be good voor 90%

 

[wpryan]

If your are not using worksheetfunctions in your code you should be good voor 90%

Hmm. Looks like that may be the culprit. I have one lines using it in a userform:

txt_PS4_v2_Reference.Value = Application.WorksheetFunction.Average(txt_PS4a_mW_v2.Value, txt_PS4b_mW_v2.Value)

which I changed to:

txt_PS4_v2_Reference.Value = (txt_PS4a_mW_v2.Value + txt_PS4b_mW_v2.Value) / 2

Let's see if that keeps the campers happy...

 

[JEC]

The average function should not cause problems. All versions do have this one. Avoiding them is still better though. In this case, It’s probably something else. Do you use dictionaries/other objects with early binding? Doe you have an example of your code which is not working in older versions?

 

[wpryan]

Hi All, thanks for your help. I've been away for a while but now I'm back... If I understand correctly what early binding is, then yes the code has some early binding (e.g., "dim ws as worksheet, pw as string, etc).