ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Converting VBA app to VB.net project (https://www.excelbanter.com/excel-programming/274724-re-converting-vba-app-vbulletin-net-project.html)

Myrna Larson[_2_]

Converting VBA app to VB.net project
 
How have you decided to work around the fact that VB.Net doesn't support variants, and requires
arrays be 0-based. i.e. how will you re-write

Dim v As Variant
v = Range("A1:B500").Value

On Mon, 18 Aug 2003 23:24:40 -0700, "Mike Burke" wrote:

I've got a couple of standalone Excel applications that I
want to make avaialbale to people who don't have Excel on
their systems. I would hate to re-write these by hand.

Does anyone know of a method or tool that will allow me to
import/convert from VBA to VB without re-writing all my
code? In the absence of a tool that will do it all (or
most) of the work, I,d be OK with a list of hints, tips
and suggested methodology from people who have had to do
this before.

Thanks,

Mike Burke




All times are GMT +1. The time now is 10:25 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com