-
Sep 25th, 2021, 06:39 AM
#41
Re: [VB6] ActiveX VBFlexGrid (Replacement of the MSFlexGrid control)
Originally Posted by southmark
I have 32-bit Excel, but how do I go about adding and using it? I added a reference to the ocx and tlb but cannot see a control to add to the palette in the form builder. What are the steps please?
You don't need to reference ocx and tlb.
Just right click add.. on the control toolbox for VBFlexGrid.
-
Sep 26th, 2021, 10:41 PM
#42
New Member
Re: [VB6] ActiveX VBFlexGrid (Replacement of the MSFlexGrid control)
Originally Posted by Krool
You don't need to reference ocx and tlb.
Just right click add.. on the control toolbox for VBFlexGrid.
Hi Krool, thanks for the response. I don't see the vbflexgrid in the toolbox. I don't have permissions to run regsvr32 on vbflxgrd14.ocx which was why I was hoping adding a reference to the ocx would do the trick. What am I missing here please?
-
Sep 27th, 2021, 02:04 AM
#43
Re: [VB6] ActiveX VBFlexGrid (Replacement of the MSFlexGrid control)
The OCX needs to be registered on your machine before you can use it from VBA.
-
Oct 4th, 2021, 02:35 PM
#44
New Member
Re: [VB6] ActiveX VBFlexGrid (Replacement of the MSFlexGrid control)
How might I install the OCX control without admin rights? Anyone?
I got rights temporarily, ran regsvr32 and verified that the control works - awesome!
I then experimented with the Microsoft Regcap tool to capture a registry file.
`RegCap /O vbflxgrd14.reg vbflxgrd14.ocx`
I edited the file to change instances of HKEY_CLASSES_ROOT to HKEY_CURRENT_USER\Software\Classes as per a number of references. I also added the 'Windows Registry Editor Version 5.00' header line to the registry file. When run it was reported to have completed successfully.
However, the control is not enabled in the control toolbox unless I again run regsvr32 as admin. Still investigating but it would be great to hear from someone who got this working.
Thank you!
Originally Posted by Krool
You don't need to reference ocx and tlb.
Just right click add.. on the control toolbox for VBFlexGrid.
Originally Posted by Arnoutdv
The OCX needs to be registered on your machine before you can use it from VBA.
Thank you both for the replies. It had been a long time since I'd used VBA! Krool, this was amazingly single to switch out the microsoft control for, amazing project!
-
Dec 19th, 2021, 12:12 PM
#45
Re: [VB6] ActiveX VBFlexGrid (Replacement of the MSFlexGrid control)
-
Mar 24th, 2022, 09:23 PM
#46
New Member
Re: [VB6] ActiveX VBFlexGrid (Replacement of the MSFlexGrid control)
Dear Krool, how can I upload a 15 mb file, I have some modifications made to vbflexgrid and I would like to upload the file
-
Mar 25th, 2022, 07:19 AM
#47
Re: [VB6] ActiveX VBFlexGrid (Replacement of the MSFlexGrid control)
@lilizanodiaz: You can use github like this
1. Clone the repo at https://github.com/Kr00l/VBFLXGRD
2. Rebase your changes on latest version of the sources
3. Create Pull Request and explain what's been done so far
Don't expect anyone to wade through 15MB of changes to merge anything (potentially a "gem") into main branch.
cheers,
</wqw>
-
Mar 25th, 2022, 10:06 AM
#48
New Member
Re: [VB6] ActiveX VBFlexGrid (Replacement of the MSFlexGrid control)
Dear Krool, I already attached it to github in the following path: lizanodiaz/vbflexgrid.
Please I would like you to adapt it to your vbflexgrid and thus be able to obtain a more complete and powerful Grid
-
Apr 17th, 2022, 06:43 AM
#49
Addicted Member
Re: [VB6] ActiveX VBFlexGrid (Replacement of the MSFlexGrid control)
Krool, am I correct in that version 1.5 is not a strait drop in replacement for version 1.4 (which I use currently) in my project? With strait I mean; looking at the form in a text editor where 1.4 has the class name "VBFLXGRD14.VBFlexGrid" I assume 1.5 will be "VBFLXGRD15.VBFlexGrid"?
In such case, would the proper upgrade path be to first register 1.5 on the developer machine and then manually edit all the forms in a text editor (changing class names), before starting my project(s) or is the a simpler and smoother way?
BTW I'm not a fan of this naming scheme of controls but I guess you have your reasons. As long as there are no broken interfaces for backward compatibility... I cannot see any good reason. Not crisism, just feedback ;-)
M$ vs. VB6 = The biggest betrayal and strategic mistake of the century!?
-
Apr 17th, 2022, 09:45 AM
#50
Addicted Member
Re: [VB6] ActiveX VBFlexGrid (Replacement of the MSFlexGrid control)
Ok, this is how I ended up upgrade from version 1.4 to 1.5 and I cannot really see any other way to do it.
1. After unpacking the zip, open an elevated command window and register the ocx: # regsvr32 VBFLXGRD15.OCX
2. Open project and add component "VB FlexGrid Control 1.5": Ctrl+T or menu Project->Components
3. Add an instance of the new control to a form as a placeholder, Save and Close the project.
4. Open the form (with added control) in your favorite text editor. Search for all instances of the previous control e.g. VBFLXGRD14, in all form files. I use Notepad++, Search in files for this, which gives me a sub window with a line for each instance.
5. Note at the top of the (placeholder control) form, a line starting with "Object = " ... ending with "VBFLXGRD15.OCX". Copy this line to the clipboard.
6. Now look for same line but ending with "VBFLXGRD14.OCX" and replace this line (or delete if present in place holder form) with the one you saved to clipboard. Do this in all forms. If using NP++ just double click the (Object = ) line and the file will open with VBFLXGRD14 highlighted. IMPORTANT. Replace the whole line, not just VBFLXGRD14, as this version has a new GUID value.
7. Now iterate through the forms again and replace the control instances, by replacing VBFLXGRD14 with VBFLXGRD15
8. Special attention with the project vbp file, find the "Object=" for VBFLXGRD14 and replace it with the VBFLXGRD15 one you save to clipboard earlier, but... pay attention, format is slightly different; no spaces around = and no ", remove these. Check with the other Object items there is uncertain about format.
9. Save and close all form files, open your project in VB6, remove the place holder control and your project is upgraded.
I hope this will help someone.
M$ vs. VB6 = The biggest betrayal and strategic mistake of the century!?
-
Apr 23rd, 2023, 03:42 PM
#51
Member
Re: [VB6] ActiveX VBFlexGrid (Replacement of the MSFlexGrid control)
[deleted, (dunno how to delete a post)]
Last edited by Chris_G33; Apr 23rd, 2023 at 04:00 PM.
-
May 5th, 2023, 01:19 AM
#52
Re: [VB6] ActiveX VBFlexGrid (Replacement of the MSFlexGrid control)
-
Jun 24th, 2023, 10:58 PM
#53
Hyperactive Member
Re: [VB6] ActiveX VBFlexGrid (Replacement of the MSFlexGrid control)
7edm,
I have a utility https://www.vbforums.com/showthread....ompile-Utility that automates updating VBFlexGrid and VBCCRxx that easily handles moving to newer versions. Let me know what you think of it...
-
Sep 9th, 2023, 09:11 AM
#54
Hyperactive Member
Re: [VB6] ActiveX VBFlexGrid (Replacement of the MSFlexGrid control)
Hi, Krool. Thank you for your last updates of the STD EXE version, but I can't find these properties in the ActiveX 1.6.35 version:
- ColComboCue;
- ColLookup;
- EditLocked.
Best regards,
Nouyana.
-
Sep 10th, 2023, 02:30 PM
#55
Re: [VB6] ActiveX VBFlexGrid (Replacement of the MSFlexGrid control)
Originally Posted by Nouyana
Hi, Krool. Thank you for your last updates of the STD EXE version, but I can't find these properties in the ActiveX 1.6.35 version:
- ColComboCue;
- ColLookup;
- EditLocked.
Best regards,
Nouyana.
They will come in future in a 1.7 version.
Until that some more other features may be added..
-
Dec 13th, 2023, 07:49 AM
#56
Re: [VB6] ActiveX VBFlexGrid (Replacement of the MSFlexGrid control)
-
Apr 12th, 2024, 04:26 PM
#57
New Member
Re: [VB6] ActiveX VBFlexGrid (Replacement of the MSFlexGrid control)
Originally Posted by R.J. Dunnill
It would work in 32-bit Excel but not 64-bit Excel. At least until I finish porting it.
great job!! I'm looking forward to the ocx control for 64 bit
-
Apr 13th, 2024, 04:53 PM
#58
New Member
Re: [VB6] ActiveX VBFlexGrid (Replacement of the MSFlexGrid control)
Originally Posted by Krool
Version 1.7 released.
Dear krool, you have done an impressive job creating this control, I have applied it in an old project (32 bits) and it worked perfectly.
Although I need to bring that project to win64, will you release the OCX control for that platform?
Last edited by caesar_cat; Apr 13th, 2024 at 06:53 PM.
-
Apr 14th, 2024, 11:42 AM
#59
Re: [VB6] ActiveX VBFlexGrid (Replacement of the MSFlexGrid control)
Originally Posted by caesar_cat
Dear krool, you have done an impressive job creating this control, I have applied it in an old project (32 bits) and it worked perfectly.
Although I need to bring that project to win64, will you release the OCX control for that platform?
We need tB (twinBASIC) for that.
The 1.7 project is already ported to tB and works in x64.
Though it's experimental as tB is still BETA.
-
Apr 14th, 2024, 05:20 PM
#60
New Member
Re: [VB6] ActiveX VBFlexGrid (Replacement of the MSFlexGrid control)
Originally Posted by Krool
We need tB (twinBASIC) for that.
The 1.7 project is already ported to tB and works in x64.
Though it's experimental as tB is still BETA.
I understand, I hope you will soon surprise us with this OCX ready to work on x64, as well as the VBCCR
Last edited by caesar_cat; Apr 14th, 2024 at 05:32 PM.
-
Apr 15th, 2024, 10:41 AM
#61
Junior Member
Re: [VB6] ActiveX VBFlexGrid (Replacement of the MSFlexGrid control)
Originally Posted by Krool
We need tB (twinBASIC) for that.
The 1.7 project is already ported to tB and works in x64.
Though it's experimental as tB is still BETA.
I was in the process of porting it to Visual C++ and ATL, until management directed my efforts elsewhere.
The port is still in the backlog, but it's not a given it will ever be greenlit again.
Most likely, for the port to move forward, I would have to do the work in my own time.
-
Apr 15th, 2024, 10:42 AM
#62
Junior Member
Re: [VB6] ActiveX VBFlexGrid (Replacement of the MSFlexGrid control)
Originally Posted by Krool
We need tB (twinBASIC) for that.
The 1.7 project is already ported to tB and works in x64.
Though it's experimental as tB is still BETA.
FYI Visual Studio Community Edition (Visual Studio Professional with different licensing) is available free of charge.
-
Apr 17th, 2024, 09:06 AM
#63
New Member
Re: [VB6] ActiveX VBFlexGrid (Replacement of the MSFlexGrid control)
Originally Posted by R.J. Dunnill
Most likely, for the port to move forward, I would have to do the work in my own time.
It would be a great contribution, I hope you can do it
-
Apr 20th, 2024, 12:57 PM
#64
Re: [VB6] ActiveX VBFlexGrid (Replacement of the MSFlexGrid control)
Updated manifest applying the miscStatus* attributes. Thanks to wqweto.
-
May 21st, 2024, 09:07 AM
#65
Addicted Member
Re: [VB6] ActiveX VBFlexGrid (Replacement of the MSFlexGrid control)
Originally Posted by MountainMan
Hi MountainMan, sorry for late reply but life ran into a road bump and had to drop all coding for a while. Now picking up the keyboard once again getting back at it.
I read your document and looked at your utility - great work - and I may consider to use it but I kind of like to do it manually, especially now, as it gives you a tour through the code and mostly is it's just a search and replace operation. I just updated from VBFLXGRD15 to VBFLXGRD17 w/o problems. Then I also decided to implement VBCCR18 replacing what I use currently and that's ongoing.
M$ vs. VB6 = The biggest betrayal and strategic mistake of the century!?
-
May 21st, 2024, 09:21 AM
#66
Addicted Member
Re: [VB6] ActiveX VBFlexGrid (Replacement of the MSFlexGrid control)
And while I'm at it, I think I never thanked you Krool, for providing this and other great controls to the community and for free. It's just outstanding!
M$ vs. VB6 = The biggest betrayal and strategic mistake of the century!?
-
Oct 12th, 2024, 07:35 AM
#67
Re: [VB6] ActiveX VBFlexGrid (Replacement of the MSFlexGrid control)
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|