Cannot find reference in visual studio

[TheBeesKnees1221]

Hello,

I am having trouble working with the Quandl Add In for Excel. First off, the Quandl Tab toolbar appears different from those I have seen in tutorial videos. This is not a problem though, as the addin seems to have all of its functionality, and I am able to Query the website for data just fine.

The idea was to set up a Macro that would be able to get the different data sets as needed. While I have tried to set the macro up to place the exact function as a string into a specific cell, the problem is that as soon as the macro is run, the Quandl Functions Check (on the toolbar) becomes disabled.This causes the program not to get the data (the data is retrieved just fine once I re-enable Quandl Functions and press the Get Data button).

I tried to solve this by recording a macro that enables the Quandl Functions and Performs the Get Data function. Nothing that I did is recorded in the Macro. After some research, I believe this is due to the lack of a reference in Visual Studio > Tools > References. The tutorials that I have watched and the posts that I have read all seemed to say that there should be a "Quandl" reference that I need to check.

Could anyone help to point me in the right direction to locate the reference? Should it automatically appear once the addin is downloaded and installed? I even went to every file within the folder and tried to manually add it to the library.

At the very least, I hope to be able to Enable Functions and Get Data through a recorded macro. But, I think that by adding this reference I will be able to perform the GetData function directly in the VBA code (I saw it multiple times in people's examples), which would save me from having to paste the function into the cell. Either way, they would both serve the same purpose.

One interesting thing to note (or at least seems so to me) is that whenever I type in the getdata("xxxx") function, it capitalizes it automatically to GetData("xxxx"). What exactly does this imply?

 

[mole999]

The function is written in that upper/lowercase style. Nothing sinister or wrong with that

 

[TheBeesKnees1221]

I guess I should have been a little more specific for the last bit of my post... the part that is confusing me about it capitalizing the GetData function is that I was under the impression it didn't have a GetData function to refer to. I get the 'sub or function doesn't exist' error if I have GetData("xxx") typed into my code. I am confused as to how it knows to capitalize the function if it doesn't have the reference for it?

 

[RoryA]

Excel's PivotTable object has a GetData method, which is where the capitalisation comes from.

BTW, the VB Editor in Office applications is not the same thing as Visual Studio - which are you talking about?

 

[TheBeesKnees1221]

Well, that clears up the capitalization, but seems to get me even further from where I want to be! I guess it was a bit of a stretch for me to assume that quandl's 'Get Data' button would be a (method? - I'm still a bit shaky on what to label things) of the same name.

I was referring to the vb editor for office.

Thanks for the responses! It seems I may need to dig a little deeper to see what the addin is actually capable of. What I was banking on (using what I thought was getdata() to query the database) no longer seems like a viable option. I will look more into that and provide any information I come across. Thanks again!