gbergsma
asked on
Converting from VBA to VB and vice versa
G'day
I have a VBA app that runs within Excel. I want to be able to export the userforms and code across to VB to make a standalone app.
The app needs to run both in the Excel environment and a standalone, so import export between VB and VBA would be very useful, but I can't figure out how to do it (can't figure out how to bring my VBA into Visual Studio - I can't seem to find an option to do this)
Any help appreciated
Cheers
Greg
I have a VBA app that runs within Excel. I want to be able to export the userforms and code across to VB to make a standalone app.
The app needs to run both in the Excel environment and a standalone, so import export between VB and VBA would be very useful, but I can't figure out how to do it (can't figure out how to bring my VBA into Visual Studio - I can't seem to find an option to do this)
Any help appreciated
Cheers
Greg
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
<I am working in Excel because my code doesnt have to go through a lengthy acceptance test to be deployed on my customers corporate network>
I know that feeling. Most of my work is with government offices, and they are quite strict about what can and cannot go onto their network. Compiled code always raises a big red flag, and more than once I've had to provide source for them to view/verify. If you REALLY want to have some fun, try putting your app into a "black box" security room ... these are rooms where stuff goes in but never comes out, the computers they use for the project are literally ground to dust before coming out of the room. I had to have my app vetted for this type of install ... talk about a hassle, they had to investigate me, my company, my wife, my dog ... took about 6 months total time. They actually WANTED an Access app for this, since it's much easier to verify and troubleshoot for the onsite techs.
I know that feeling. Most of my work is with government offices, and they are quite strict about what can and cannot go onto their network. Compiled code always raises a big red flag, and more than once I've had to provide source for them to view/verify. If you REALLY want to have some fun, try putting your app into a "black box" security room ... these are rooms where stuff goes in but never comes out, the computers they use for the project are literally ground to dust before coming out of the room. I had to have my app vetted for this type of install ... talk about a hassle, they had to investigate me, my company, my wife, my dog ... took about 6 months total time. They actually WANTED an Access app for this, since it's much easier to verify and troubleshoot for the onsite techs.
ASKER
Easy to understand feedback, however there is no solution for my issue because Microsoft has no way to merge the two environments. Nice to be talking to someone going through the same hassles with government - and know I am not alone :-)
ASKER
Thanks anyway
Cheers
Greg