PDA

View Full Version : how t oget info on this function?



choubix
02-16-2008, 05:48 AM
hello,

I have a macro that retrieves info from yahoo (historic data)

within the code there is a reference to "GetHistory" but I can't find the function in the modules. I'd like to explore this function to see how the data is retrieved.

How can I find info on this function? (nothing in the Object Browser...)

on top of that I don't get what oYH and boYHIstantiated mean...

This is a chunk of the code.

boYHInstantiated = False
If boYHInstantiated = False Then
Set oYH = CreateObject("YHOHist.main")
boYHInstantiated = True
End If
nrows = oYH.GetHistory(ticker, StartDate, EndDate, UCase(frequency), IncludeAllDays)

hope someone can shed some light on this for me! :)

thanks!
A.

Norie
02-16-2008, 06:24 AM
There is no such function in Excel or VBA.

What is YHOHist.main? An add-in?

choubix
02-16-2008, 08:19 AM
hello,

I finally managed to get hold of the function. it was hidden in a different .xla!
funny thing: I can't find: YHOHist.main ...

Norie
02-16-2008, 09:15 AM
hello,

I finally managed to get hold of the function. it was hidden in a different .xla!

That means it's part of an add-in.

And I too couldn't find anything for YHOHist.main - not on my computer, not on the internet, not in any Help file and not in the Object Browser.:dunno

choubix
02-16-2008, 12:50 PM
thanks for having taken a look at it!
I'll keep looking in the add in...