Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel VBA to VB
Is it possible to export a small excel vba project to
a "stand alone" vb program? Regards Lars Kofod |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel VBA to VB
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.../Q219/1/51.ASP Q219151 - HOWTO: Automate Excel 97 and Excel 2000 from Visual Basic http://support.microsoft.com/support.../q167/2/23.asp Microsoft Office 97 Automation Help File Available on MSL http://support.microsoft.com/support.../Q123/8/59.asp ACC: Sample OLE Automation for MS Word and MS Excel http://support.microsoft.com/support.../Q142/4/76.asp Q142476 - ACC: Using Automation to Create and Manipulate an Excel Workbook http://support.microsoft.com/support.../q184/2/73.asp ACC97: How to Use Automation to Create a Microsoft Excel Chart http://support.microsoft.com/support.../q129/3/04.asp ACC: Using Automation to Transfer Data to Microsoft Excel http://support.microsoft.com/support...aqVBOffice.asp Frequently Asked Questions about Microsoft Office Automation Using Visual Basic http://support.microsoft.com/support...fdevinapps.asp Programming Office from Within Office http://support.microsoft.com/support...automation.asp Using Automation with Microsoft Excel 97 http://support.microsoft.com/support.../q170/7/45.asp XL97: How to Create PivotTable from Word http://support.microsoft.com/support.../q177/7/60.asp VBA: How to Run Macros in Other Office Programs http://support.microsoft.com/support.../q153/7/48.asp ACC: How to Call Excel Functions from Within Microsoft Access http://support.microsoft.com/support.../q167/2/23.asp Microsoft Office 97 Automation Help File Available on MSL http://support.microsoft.com/support.../q159/9/22.asp XL97: Using Quit Method May Cause Illegal Operation http://support.microsoft.com/support.../q145/7/70.asp ACC: Automation Does Not Close Microsoft Excel http://support.microsoft.com/support.../q199/2/19.asp XL2000: Automation Doesn't Release Excel Object from Memory http://support.microsoft.com/support.../q213/6/02.asp XL2000: CreateObject and GetObject Work Differently http://support.microsoft.com/support.../q114/3/47.asp INFO: OLE Automation Objects with GetObject and CreateObject http://support.microsoft.com/support...151/introd.asp Office for Windows An Introduction to OLE Automation http://support.microsoft.com/support.../Q234/7/74.ASP HOWTO: Automate Excel from an HTML Web Page Using JScript http://support.microsoft.com/support.../Q198/7/03.ASP HOWTO: Automating Excel From Client-Side VBScript Regards, Tom Ogilvy Lars Kofod wrote in message ... Is it possible to export a small excel vba project to a "stand alone" vb program? Regards Lars Kofod |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel VBA to VB
I believe that you can export the modules and/or class
modules and then import them into VB. Seth -----Original Message----- Is it possible to export a small excel vba project to a "stand alone" vb program? Regards Lars Kofod . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel VBA to VB
"Lars Kofod" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|