search

ClimberMel / SMF_Add-in

Stock Market Functions for Excel using VBA
https://climbermel.github.io/SMF_Add-in/
14 stars 5 forks source link

Compile error #12

Closed ClimberMel closed 1 year ago

ClimberMel commented 1 year ago

Just want to document the fixes... The problem was a compile error (sub or function not defined). Here's the coding segment that caused the issue:

Dim iDim1 As Integer, iDim2 As Integer iDim1 = pDim1 iDim2 = pDim2 If pDim1 = 20000 And pDim2 = 7 Then On Error Resume Next iDim1 = Application.Caller.Rows.Count iDim2 = Application.Caller.Columns.Count End If

RCHGetYahooHistory = testGetYahooHistory(pTicker, _
                                        pStartMonth & "/" & pStartDay & "/" & pStartYear, _
                                        pEndMonth & "/" & pEndDay & "/" & pEndYear, _
                                        pPeriod, sItems, pNames, pResort, iDim1, iDim2)
ClimberMel commented 1 year ago

The error was due to calling testGetYahooHistory instead of smfGetYahooHistory. I had created a clone and called it testGetYahooHistory to work side by side with the original code. I removed the test module when done, but forgot to change the calling statement back! Fixed and xla has been replaced.