| || |
Importing Excel datas to ActiveData??
I am writing a function to perform the data parameterization without using ActiveData wizard. I am in need of help to import the data's from the Excel sheet to the ActiveData Sheet at run time using TPL or VBA. Can anyone help me how to achieve this through code, without using the wizard? I looked at TP Help, but only the code for loading ActiveData using TActiveData object is given. Please help me in doing this. I am in process of building a framework that will assit TP. Expecting your valuable help. Thanks.
Re: Importing Excel datas to ActiveData??
This doesn't directly answer your question, but I normally load an excel file and put it in a class module that can be used later. All the functions I use to do Excel manipulation is in this post. Any questions on how to do this let me know. (BTW, I put all these functions in a shared module).