Win 8.1 Excel 2010 VBA Missing:ScriptingObjectModel

Question

I have a working Win 7 Excel 2010 VBA using the split text function among others.  When I try to execute the VBA in the same workbook on Win 8.1 Excel 2010, I get the Missing:ScriptingObjectModel in the References tool.  I've tried downloading WSH 5.7 but get an insufficient space error with 153 GB free on the C: drive and 28.8 GB memory free.  I'm at a loss other than a brute force writing of the scripting functions in VBA.

Answer 1

The Split functions are in VBA, that they did not work is only a symptom, causes by the MISSING reference.

Repair the reference or change your code to late binding and the issue is gone.

If you need further help please upload your file (maybe with anonymous data) on an online file hoster like www.dropbox.com and post the download link here.

Andreas.

Answer 2

Andreas--

Much to my surprise, the file now runs with no difficulty and no scripting reference.  When I turned the laptop on to get the screen shots, a large number of updates were installed.  I'm guessing that one of those updates solved the missing reference problem.  I'll watch for that in the future.

I apologize for the confusion.

--student-t

Answer 3

Andreas--

A new file in dropbox: https://www.dropbox.com/s/8klepba9zo0i005/Sample_M_DebugWin8.1.xlsm?dl=0.  this one has my function split changed to splitxxx to prevent use of my function by the call to split.  This works just fine in my Win 7 computer but fails for missing object reference to scripting in Win 8.1.  

I'll get the screen shots a bit later when I transfer over to my laptop as it's the one with Win 8.1 on it.

--Walt

Answer 4

However, if the replacement Split function is commented out to use the VBA Split function, the problem recurs.

Nope, no missing references or errors, when I click the "Generate" button the macro runs without any issues.

Show me your original file and a screenshot(s) with the issue.

EDIT: Yes, I have Win8.1 and Excel 2010

Andreas.

Answer 5

The link to my code in dropbox is https://www.dropbox.com/s/cbrs7wj7thaxpom/Sample_M.xlsm?dl=0.  Please note that I have coded a replacement for the Split function and that the reference problem does not exist.  However, if the replacement Split function is commented out to use the VBA Split function, the problem recurs.

I cannot determine how to supply the missing reference either by searching my hard disk or on the net.  And, while I understand late binding as it applies to objects and even methods of objects, I do not understand late binding for a function such as split. 

As I noted originally, this is not a problem in Windows 7 and only arises in Excel 2010 with Windows 8.1 (and perhaps other versions of Windows and Excel).

--student-tt