L
Legacy 15162
Guest
i ran the code, it was successful, except this portion did not populate in the spread sheet....
GetEquation = "="
k = Me.TxtBeginPeriod
For j = 1 To Periods
GetEquation = GetEquation & "+'\\APC-SQL\Reports\Flow Thru\Period FT P&Ls\" & Me.TxtYear & "\[P" & k & "FTP&L.xls]" & stWkshtName & "'!$I11"
k = k + 1
Next j
.Range("I11") = GetEquation
what did i mess up?
btw, periods = txtEndPeriod - TxtBeginPeriod
GetEquation = "="
k = Me.TxtBeginPeriod
For j = 1 To Periods
GetEquation = GetEquation & "+'\\APC-SQL\Reports\Flow Thru\Period FT P&Ls\" & Me.TxtYear & "\[P" & k & "FTP&L.xls]" & stWkshtName & "'!$I11"
k = k + 1
Next j
.Range("I11") = GetEquation
what did i mess up?
btw, periods = txtEndPeriod - TxtBeginPeriod