Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Development Tools
 Other Development Tools
 convert VBA code to VB6

Author  Topic 

Mamatha
Posting Yak Master

102 Posts

Posted - 2005-02-04 : 05:27:19
Hi

I have VBA code and forms are designed using Excel...now i want to convert VBA code to VB6.Is it possible to convert?
I read one article at microsoft in this link

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odc_vsto2003_ta/html/VBAConvert.asp

But i was unable to see Microsoft Office 2003 link on Visual studio.
Please give me the solution to convert VBA code to VB6 or converting VBA to VB.NET.





Mamatha

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2005-02-04 : 05:36:29
my advice is don't converet it. rewrite it.
if you're going to convert it you're going to need twice as much time to debug the stuff and fix
all of the errors than if you would when rewriting it.

Go with the flow & have fun! Else fight the flow
Go to Top of Page

Auric
Yak Posting Veteran

70 Posts

Posted - 2005-02-04 : 10:27:14
Mamatha how large of a VBA app is it?

re-writing a VB6 app to access a SQL server using ADO is really really easy.

Select * from users where clue > 0
Go to Top of Page
   

- Advertisement -