PDA

View Full Version : Converting QuickBasic functions to VBA functions



zizou
06-16-2008, 02:04 PM
Hi all. I have all this code in Quickbasic. I copied it all over to VBA, but the code is not working in VBA, because some/most of the functions used in Quickbasic are not recongized in VBA. I was wondering if anyone knows a quick way to fix this or switch all the quickbasic functions to VBA functions, so that the program will run in VBA. I need all the help I can get. Thanks.:help

Tommy
06-16-2008, 06:41 PM
Hi zizou,

I have done this but it isn't easy. If you could post some of the code we may be able to "convert" but you may also have to rewrite some functions. Most of it is just reworking it but it is a intinsive.

zizou
06-19-2008, 06:34 AM
Tommy,
Thanks for the reply. It is a lot of code, but I have to ask my boss if I can put it on a forum. Hopefully I can. I will let you know soon. Thanks again

Tommy
06-19-2008, 07:27 AM
You could pm some of the more "private" subs and post the utilities. Then we could comminicate the problems and the solutions. :)

Tommy
06-19-2008, 07:28 AM
Also what vba object model are you trying to use? Excel, Word, Access, Acad, Powerpoint .......

zizou
06-19-2008, 11:24 AM
well im trying to make a program in VB, but i guees it is more directed in excel. Is there any way I could send it to you, instead of posting it over the forum? Thanks

zizou
06-19-2008, 11:25 AM
And what do you mean by PM the subs and post the utilities.

Tommy
06-19-2008, 12:35 PM
PM - private message, it's like e-mail but through the forum. I was suggesting that you send the subs you can't post on the forum and we could work out the problems through the forum and keep the confidential information secure. This way everyone benifits. You can also go to my profile and send an e-mail to me.

VB is that VB6? If so that is still doable. If you are talking about VB.NET I would suggest just rewrite it. You would be way ahead if you did.

zizou
06-19-2008, 02:05 PM
Tommy,
Im talking about VB6. I will get the 3 programs tomorrow and send a PM to you. Thanks a bunch. I really appreciate it.