Thread: Excel VBA to VB
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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