Keep Scripting Runtime References Enabled Always In My Excel VBA

Once I close and reopen excel the reference to Microsoft Scripting Runtime getting disabled from excel vba.

Any suggestion about how to keep it enabled?

References are workbook specific. If you really want it set for all workbooks (which seems odd to me), you would need to create a book.xltm template and use that.

Hi Rory,

Thanks for the solution

Is it possible to establish the reference in the xlStartup file so that it can be made available in all excel workbook? I tried to do this and see how it works but I don't see any excel file in xlStart and startup folder. Both are empty...

Originally Posted by romperstomper

you would need to create a book.xltm template and use that.

As per your suggestion I have to use that template file (ALONE) whenever I am in need of using Scripting.Dictionary reference made available to use? Rather than using any workbook without establishing the connection manually...?

Please let me know if there is any solution to make it readily available in all excel workbook I create/open

Hi Marc L,

Thanks for suggesting Late Binding method, but while writing code I would like to use Early Binding method and when I release the code for OP's I will convert it to late binding.

But I want to keep the references established in all workbooks instead of manually building the references. Even microsoft doesn't kept a search field to quicky pick the desired reference. Scrolling down to the reference is a hectic one for me..

Any other suggestions?

Why do you want to add the reference to existing workbooks since they presumably don't already require it?

BTW, if you add the reference to your Personal macro workbook, that reference should remain near the top of the references list even when you have another workbook active, so you don't have to go looking for it.

Originally Posted by romperstomper

Why do you want to add the reference to existing workbooks since they presumably don't already require it?

Mostly, I download the OP's file and write VBA code and I would like to use early binding for (Intellisense / auto-completion) accessing the dictionay propery/methods which will help me in writing the code with lesser time.

Originally Posted by romperstomper

BTW, if you add the reference to your Personal macro workbook, that reference should remain near the top of the references list even when you have another workbook active, so you don't have to go looking for it.

Wow!!! That is a nice tip and I created a record macro to get the Personal.xls and turned on the References. As you said its showing in top in fresh workbooks for easy access.

Still looking to make it enabled in all workbooks....

Hi Kyle123,

I know it is very less in Dictionary (i.e.) The Dictionary class has four properties and six methods only so it is not a big deal.

But I am becoming very lazy nowadays or I don't want to waste my time in typing the properties/methods of the objects. I would like to auto load it to save my code writing time also I need not to add/keep the unnecesary junks (Methods/Properties) in my mind when it is readily available in the system itself

Assuming you have trusted access to the VBA project set in your Trust Center settings, you could use:

Please Login or Register  to view this content.

but you have to run it per workbook.

Hi,

Or you can use the notorious sendkeys() :

Please Login or Register  to view this content.

Run the code in VBA window, not in spreadsheet window. The code itself can be stored in Personal.xl* for later use.

Regards

Originally Posted by romperstomper

Assuming you have trusted access to the VBA project set in your Trust Center settings, you could use:

Wow!!! You made it handy!!!!

Surely, it's going to save lot of my time....

I am going to mark it sovled happily

Originally Posted by Kyle123

Or run it on the application's workbook_open event

Thanks for the suggestion

Hitting Alt+F8 and enter is not a big deal for me since I am a lightening speed keyboard user