-
Jul 3rd, 2022, 12:51 PM
#1
Converting VB6 add-in
I have the code for a VB6 add-in that I wrote many years ago. It was (of course) written in a 32-bit environment and it added certain useful functions to the Excel toolbar. Those functions brought up forms that I then used to enter text into the code in my workbook's macros. I'd like to convert or rewrite that add-in so that I can use it in 64-bit Excel. How would I go about doing that?
-
Jul 3rd, 2022, 02:30 PM
#2
Re: Converting VB6 add-in
https://github.com/yereverluvinunclebert
Skillset: VMS,DOS,Windows Sysadmin from 1985, fault-tolerance, VaxCluster, Alpha,Sparc. DCL,QB,VBDOS- VB6,.NET, PHP,NODE.JS, Graphic Design, Project Manager, CMS, Quad Electronics. classic cars & m'bikes. Artist in water & oils. Historian.
By the power invested in me, all the threads I start are battle free zones - no arguing about the benefits of VB6 over .NET here please. Happiness must reign.
-
Jul 3rd, 2022, 03:04 PM
#3
Re: Converting VB6 add-in
You wrote it in VB6 not VBA? VBA is 64 bit I believe so maybe you might find the answer there. My experience with VBA is very limited so I can't say for sure.
-
Jul 3rd, 2022, 03:59 PM
#4
Re: Converting VB6 add-in
Originally Posted by Niya
You wrote it in VB6 not VBA? VBA is 64 bit I believe so maybe you might find the answer there. My experience with VBA is very limited so I can't say for sure.
Yes VB6. I initially wrote it for VB6 which has a UI similar to Excel and with a few simple changes I made one for 32 bit Excel since (I think) at that time Excel 64 bit didn't exist.
-
Jul 3rd, 2022, 04:18 PM
#5
Lively Member
Re: Converting VB6 add-in
In trying to improve in VBA, I end up converting projects written in VB6 to VBA fairly frequently. It really all depends on what it is that you add-in tries to do. If it's just a matter of converting API declarations, then one source of information is the MS file. If your addin uses controls such as listview, treeview, etc., then it's worth checking out this post if you don't already have it set up on your system.
-
Jul 3rd, 2022, 05:44 PM
#6
Re: Converting VB6 add-in
Thanks Dan. I've actually implemented a replacement listview control in 64 bit Excel. Have you ever concerted a VB6 dll to 64 bit?
-
Jul 3rd, 2022, 05:46 PM
#7
Re: Converting VB6 add-in
yereverluvinuncleber. Have you ever used TwinBasic? I emailed them describing what I want to do.
-
Jul 3rd, 2022, 05:49 PM
#8
Lively Member
Re: Converting VB6 add-in
VBA doesn't compile DLL files. For that, you could try using TwinBasic which I've started exploring and looks very promising.
-
Jul 3rd, 2022, 11:40 PM
#9
Re: Converting VB6 add-in
TwinBASIC is currently in BETA. While it is certainly very mature in it's capabilities I'd be weary of using it for production code so soon.
-
Jul 4th, 2022, 12:52 AM
#10
Re: Converting VB6 add-in
Depending on what that DLL is supposed to do, and if any other Programs access it/depend on it, it should be fairly easy to convert it to VBA
In general: converting vb6-anything to VBA is not that hard, as long as you don't use any third-party-anything (dll, controls etc.), or any special properties
Last edited by Zvoni; Tomorrow at 31:69 PM.
----------------------------------------------------------------------------------------
One System to rule them all, One Code to find them,
One IDE to bring them all, and to the Framework bind them,
in the Land of Redmond, where the Windows lie
---------------------------------------------------------------------------------
People call me crazy because i'm jumping out of perfectly fine airplanes.
---------------------------------------------------------------------------------
Code is like a joke: If you have to explain it, it's bad
-
Jul 4th, 2022, 06:28 AM
#11
Re: Converting VB6 add-in
An article I read suggested that the dll could be saved as an exe which I've done. How to I register it in 64 bit?
-
Jul 4th, 2022, 06:44 AM
#12
Re: Converting VB6 add-in
Originally Posted by MartinLiss
yereverluvinuncleber. Have you ever used TwinBasic? I emailed them describing what I want to do.
The developer is very approachable and really engaged with his task of bringing VB6 into the 21st century. There is also the other potential option RADBasic. I'd keep an eye on those two if you want to create 64bit compilable standalone VB6-type apps. If you are developing for Excel then it might be wise to migrate to VBA. Note that Wayne Phillips (TwinBasic) has an eye on capturing the VBA market too so VBA isn't a bad idea.
https://github.com/yereverluvinunclebert
Skillset: VMS,DOS,Windows Sysadmin from 1985, fault-tolerance, VaxCluster, Alpha,Sparc. DCL,QB,VBDOS- VB6,.NET, PHP,NODE.JS, Graphic Design, Project Manager, CMS, Quad Electronics. classic cars & m'bikes. Artist in water & oils. Historian.
By the power invested in me, all the threads I start are battle free zones - no arguing about the benefits of VB6 over .NET here please. Happiness must reign.
-
Jul 4th, 2022, 07:46 AM
#13
Re: Converting VB6 add-in
OK, let's get something out of the way:
Is this "Add-In" of yours a (vb6) DLL or is it an Excel Add-In (xla/xlam)?
I'm asking for the File-Format
Last edited by Zvoni; Tomorrow at 31:69 PM.
----------------------------------------------------------------------------------------
One System to rule them all, One Code to find them,
One IDE to bring them all, and to the Framework bind them,
in the Land of Redmond, where the Windows lie
---------------------------------------------------------------------------------
People call me crazy because i'm jumping out of perfectly fine airplanes.
---------------------------------------------------------------------------------
Code is like a joke: If you have to explain it, it's bad
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
|