if you are using it in excel, then you can simply select the cell and
cells(row,column).formula = cells(row,column).value
That will freeze the value and you can capture.
In case you want to revert back to the formula, you can save it in a variabl…
Hi,
Went thru the link again today. Actually, this is where I had started a few months ago and have progressed quite well.
However regret to mention that there nothing about historical prices on that page.
kindly review my question and your repl…
I have written the exact code while stating the problem.
However, I have now been able to resolve it by using the CStr() function to explicitly convert the OrderID and the ParentOrderID into strings before passing them as parameters.
