Excel-VBA

F

falconshh

I have a package of SSIS , this package can create and edit a excel file by
using VBA with installed office environment .

With no office environment , that package can create ,but not edit that
excel file..

Excel.dll, Office.dll and VBIDE.dll are necessary??
 
B

Bob Phillips

So what is the question?

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
B

Bob Phillips

No because VBA is a hosted facility, it can only run with the hosting
container such as Excel, Word, etc.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
C

Chip Pearson

with no office environment, VBA can be executed ?

Strictly speaking, if the host application runs VBA then, yes, VBA can be
executed by that host application, even if no Office environment is present.
However, the VBA code cannot do anything with libraries that are not
present, so it cannot modify any part of a workbook.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel, 10 Years
Pearson Software Consulting
www.cpearson.com
(email on the web site)
 
Top