Limited help from err message
Hi all,
got little help from an error message that I gather (from google) is pretty
ra
External Data Source Failed to Connect.
it happens when I execute this line for the *second* time:
oChart.SetData cChartConstants.chDimCategories, 0, "a2:" & LastRow
It binds the specified constant to a specific set of cells on oChart.
My guess is that the problem stems from rebinding.... but I need to somehow
alter the range of data bound... and I can't figure out how to do this, and
also avoid re-executing the SetData method on chDimCategories in the event
that they are already bound (I guess I need to devise a test).
This is all in relation to Office Web Controls, in case that matters.
Thanks again for your generous help...
Mike
|