VBA to VB??

[K_Man95]

Can you take code from VBA in Excel and migrate it into straight VB Studio? How difficult would it be to convert code in VBA into VB code without having to start over?

 

[zacemmel]

It's not very hard at all. Basically what's required is creating an application object that points to excel. From there, you just reference the object like you would any other object:

myXLAPP.workbooks("myworkbook").sheets("mysheet").range("myrange").value

 

[K_Man95]

That is cool..... my concern is then I still have some limitations in Excel. I strictly want to take what I have in Excel and migrate it over to VB so that I no longer have Excel attached... not even pointing to it or referencing an object or anything... I just want to stop using VBA and start using VB without having to start all over. Is there a way to do that?
This message was edited by K_Man95 on 2002-10-25 20:36

 

[zacemmel]

Uhh, not sure what you are asking exactly. If your code doesn't interract with Excel, why did you even code it in Excel VBA to begin with?

 

[K_Man95]

When I got started on this project, it was already started in Excel for me. I have just taken it further. Well, over the course of a few months as this tool has started to develope, my collegues and I have come up with new ideas for this tool, but we don't want to have wasted all our time. We were hoping that we could just migrate directly over to VB without loosing that which we already have. I know, I forgot to look into the crystal ball to foresee this coming.... lol. Just asking if this can be done and if so, how difficult? or will this mean starting over from scratch?

 

[zacemmel]

Most of the functions in VB are the same as they are in VBA. It just depends what kind of stuff you are doing.... It depends on the code, methods, etc

Might want to check the site below