Excel VBA Missing Reference to Microsoft Scripting Runtime

Question

When I am in the VB Editor on a clients computer, and i choose tools > references and want to check Microsoft Scripting Runtime, it is missing. Is that because the user is not an administrator? TIA for advice

Answer 1

Re: reference to MS Scripting Runtime

You must be on a computer running windows.

Click the 'Browse' button in the references dialog and search for the "scrrun.dll"

On a Windows XP machine it is found in Windows/System32

'---

Jim Cone

Portland, Oregon USA

https://goo.gl/IUQUN2 (Dropbox)

(free & commercial excel add-ins & workbooks)

Answer 2

Re:  Can MS Scripting Runtime be used on a MAC

I do not know and I doubt it.

Suggest you make a separate post in the MAC forum section and reference MAC in the Subject line.

You should also say what you are trying to do.  There may be an alternate method.

'---

Jim Cone

Answer 3

So there is no way for this to work on mac eh?

Answer 4

Re: is there a list that maps which dlls control what

You are welcome.

There is no list of .dlls that I am aware of.

'---

Jim Cone

Answer 5

That was an awesome answer, thank you, but i need to ask, is there a list anywhere that maps which dlls control with references?