reference library

I have to enable the following reference library to execute SQL commands in VBA. While I have added my UDF into my startup workbook, the reference library becomes unchecked every time I open and close Excel? How do I get it to stay added whenever I open my startup workbook? Libary: Microsoft...

Has anyone compiled a list or an index of Common Reference Libraries with general descriptions of functionality or intended use? I found this: https://bettersolutions.com/vba/visual-basic-editor/references-common-libraries.htm but it is quite limited considering the large number of libraries...

Hi. I am referencing Microsoft Scripting Runtime in my VBA code because I use dictionaries. However, this reference reset after every startup. How can I retain this between startups so that I only need to activate it once? Or better yet is there a way to do this inside the code similar to...

I have a excel add in built in excel 2013. Half of my team has 2013, half of my team has 2010... One of the References I use in the code is: "Microsoft Office 15.0 Object Library" The team members that have office 2013, have no problems. The teammates that have Office 2010, it throws a...

I'm pulling data from SAP at work using VBA and SAP's built in Sript Recording and Playback tool. Within Excel there are many, many SAP reference libraries I just need the correct .dll so when I'm calling a SAP sripct command such as: session.findById("wnd[1]/usr/ctxtDY_PATH").Text as I get to...

Hi there, hope someone can help me with this one. It's a 2 part question and might turn out to be a novel. Part one: I have 2 sheets. One is a reference library 3 columns wide containing information such as: <tbody> Exterior Roof Cladding Interior Door Door Closer etc </tbody> Note...

I am curious if anyone has collected any resources (or knows where I can find them) that detail how VBA searches and parses the web. I have read posts, visited microsoft's development resource center and read articles on how specific tasks may be accomplished using internet controls and...