Go Back  Xtreme Visual Basic Talk > Legacy Visual Basic (VB 4/5/6) > VBA / Office Integration > Excel > Need help - Taking VBA code/form -> vb6 standalone .exe


Reply
 
Thread Tools Display Modes
  #1  
Old 03-31-2004, 08:54 AM
Biff0rz Biff0rz is offline
Freshman
 
Join Date: Jul 2003
Posts: 39
Default Need help - Taking VBA code/form -> vb6 standalone .exe


I have created a form in Excel VBA with code and one of the developers here wants to change it over to an .exe file using VB6. I thought it was as simple as exporting the form from vba, then importing to vb6. He says when you export it none of the controls export with it. What is the best process to do something like this?
thanks
-Steve
Reply With Quote
  #2  
Old 03-31-2004, 09:37 AM
Mike Rosenblum's Avatar
Mike Rosenblum Mike Rosenblum is offline
Microsoft Excel MVP

Forum Leader
* Guru *
 
Join Date: Jul 2003
Location: New York, NY, USA
Posts: 7,848
Default

VBA uses what it calls a "UserForm", while VB 6.0 uses "Forms". They are substantially identical, but not compatible.

Code can generally be copy-pasted and then adjusted (usually minor adjustments, sometimes more major) but Forms need to be re-done from scratch. Well, the controls have to be redone from scratch, anyway, the code within the various events may be more or less valid, but the Event names themeselves will be subtly different, for the most part...
__________________
My Articles:
| Excel from .NET | Excel RibbonX using VBA | Excel from VB6 | CVErr in .NET | MVP |
Avatar by Lebb
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
'Bad' VBA causing Excel to crash on open AvgJoe Excel 0 07-07-2003 01:34 PM
standalone applications using VBA Thara Word, PowerPoint, Outlook, and Other Office Products 19 06-25-2003 04:38 AM
Converting VBA to VB6 .exe onedsla Word, PowerPoint, Outlook, and Other Office Products 2 04-22-2002 11:43 AM
Yoderic's Battle Arena -- Come And Play!! JDYoder Game Programming 4 12-11-2001 09:59 AM

Advertisement:





Free Publications
The ASP.NET 2.0 Anthology
101 Essential Tips, Tricks & Hacks - Free 156 Page Preview. Learn the most practical features and best approaches for ASP.NET.
subscribe
Programmers Heaven C# School Book -Free 338 Page eBook
The Programmers Heaven C# School book covers the .NET framework and the C# language.
subscribe
Build Your Own ASP.NET 3.5 Web Site Using C# & VB, 3rd Edition - Free 219 Page Preview!
This comprehensive step-by-step guide will help get your database-driven ASP.NET web site up and running in no time..
subscribe
 
 
-->