Hi,
Can any one tell me how to add msflexgrid in VBA. I know how to add flexgrid in VB but i couldn't find it in VBA. i don't have VB in my machine now. I also tried downloading MSflexgrd.ocx and registered but when i tried to add to the userform the error message says: "the control could not be created because it is not properly licensed".

So can any help me with this...

Thanks
Johnson

hi Raj

I am also facing the same problem with msflexgrid control and vba.

But i am facing the problem in deployment scenario. In my dev machine i hav VB. In my deployment machine i dont hav vb.

Did you get the solution. Please help me

with regards
krithi

I have actually found myself with the same problem, I have also noticed a problem using the trim function. But on the client workstation I've been able to right click on the toolbox and add the MSFlexGrid, then add it to the project and it will then work ok, but I haven't figured out how to make it show up on its own.

Found this today searching for the answer:
http://groups-beta.google.com/group/...8dc3c68e545815

might help, here is a selection of it:
We had this same problem with several active X controls,
including MSFlexGrid.
This is what we did:
We put the following in a setup.bat file in folder <X>:


---------------
echo off
copy controls\*.* c:\winnt\system32
c:
cd \winnt\system32
installcontrols
Echo on
Echo "Done"
pause

----------------
Put the following in file called InstallControls in a
folder <X>\Controls
regsvr32 msflxgrd.ocx


maybe that will help!

Another issue i've found (i'm working on this most of the day at work now) is that I develope it on Windows 2000 Pro, and it works ok on other 2000 Pro computers, but it doesn't work on XP!

Anyone else notice that?

jake

Hi Jake,

I tried the link but i still have the same problem. The process says the msflxgrd.ocx registered but when it tried to drag the flexgrid over the form the error appears: ""the control could not be created because it is not properly licensed".

Can any help me with this... Its driving me crazy.....

Thanks

Johnson

I found this site: http://www.10tec.com/ the other day which sales a solution for $100. I downloaded the trial and it actually works great, it is a very powerful tool that saved the day. You might want to look into getting it. Another idea is to go into the VB editor and under the menu item Tools click References and make sure that only the needed References are checked, I found about 5 extra references in mine that were causing problems. That might help some also!

Good luck,
jake

Hi Jake

It seems to very useful, but the problem is its a demo...

Thanks a lot

Johnson