Excel VBA to VB

[Lars Kofod]

Is it possible to export a small excel vba project to
a "stand alone" vb program?

Regards
Lars Kofod

 

[Tom Ogilvy]

Probably not without doing some additional work.

Depends on what it does.

Here are some sources of information on using Automation.

http://support.microsoft.com/support/kb/articles/Q219/1/51.ASP
Q219151 - HOWTO: Automate Excel 97 and Excel 2000 from Visual Basic

http://support.microsoft.com/support/kb/articles/q167/2/23.asp
Microsoft Office 97 Automation Help File Available on MSL

http://support.microsoft.com/support/kb/articles/Q123/8/59.asp
ACC: Sample OLE Automation for MS Word and MS Excel

http://support.microsoft.com/support/kb/articles/Q142/4/76.asp
Q142476 - ACC: Using Automation to Create and Manipulate an Excel Workbook

http://support.microsoft.com/support/kb/articles/q184/2/73.asp
ACC97: How to Use Automation to Create a Microsoft Excel Chart

http://support.microsoft.com/support/kb/articles/q129/3/04.asp
ACC: Using Automation to Transfer Data to Microsoft Excel

http://support.microsoft.com/support/OfficeDev/FaqVBOffice.asp
Frequently Asked Questions about Microsoft Office Automation Using Visual
Basic

http://support.microsoft.com/support/OfficeDev/offdevinapps.asp
Programming Office from Within Office

http://support.microsoft.com/support/excel/content/Automation/automation.asp
Using Automation with Microsoft Excel 97

http://support.microsoft.com/support/kb/articles/q170/7/45.asp
XL97: How to Create PivotTable from Word

http://support.microsoft.com/support/kb/articles/q177/7/60.asp
VBA: How to Run Macros in Other Office Programs

http://support.microsoft.com/support/kb/articles/q153/7/48.asp
ACC: How to Call Excel Functions from Within Microsoft Access

http://support.microsoft.com/support/kb/articles/q167/2/23.asp
Microsoft Office 97 Automation Help File Available on MSL

http://support.microsoft.com/support/kb/articles/q159/9/22.asp
XL97: Using Quit Method May Cause Illegal Operation

http://support.microsoft.com/support/kb/articles/q145/7/70.asp
ACC: Automation Does Not Close Microsoft Excel


http://support.microsoft.com/support/kb/articles/q199/2/19.asp
XL2000: Automation Doesn't Release Excel Object from Memory

http://support.microsoft.com/support/kb/articles/q213/6/02.asp
XL2000: CreateObject and GetObject Work Differently

http://support.microsoft.com/support/kb/articles/q114/3/47.asp
INFO: OLE Automation Objects with GetObject and CreateObject


http://support.microsoft.com/support/office/content/q140151/introd.asp
Office for Windows An Introduction to OLE Automation

http://support.microsoft.com/support/kb/articles/Q234/7/74.ASP
HOWTO: Automate Excel from an HTML Web Page Using JScript

http://support.microsoft.com/support/kb/articles/Q198/7/03.ASP
HOWTO: Automating Excel From Client-Side VBScript


Regards,
Tom Ogilvy

 

[Seth]

I believe that you can export the modules and/or class
modules and then import them into VB.

Seth

 

[Keith Willshaw]

Is it possible to export a small excel vba project to
a "stand alone" vb program?

Regards
Lars Kofod

That depends on what the program is doing. If it interacts
with Excel in any significant way then its difficult to
make it stand alone as you are relying on having Excel
installed on the target machine.

If you are simply using Excel as a programming environment
and all I/O is via user forms and vb then its easier.

You can export code modules and forms
but youd'd probably want to redo the forms as they
come into VB as a 'designer' since the form
definition is different from VB to VBA.

Keith