Excel-VBA
 

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??

Excel-VBA
 

So what is the question?

--
---
HTH

Bob

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



"falconshh" wrote in message
...
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??

Excel-VBA
 

the question is:
with no office environment, VBA can be executed ?

"Bob Phillips" wrote:

So what is the question?

--
---
HTH

Bob

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



"falconshh" wrote in message
...
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??

Excel-VBA
 

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)



"falconshh" wrote in message
...
the question is:
with no office environment, VBA can be executed ?

"Bob Phillips" wrote:

So what is the question?

--
---
HTH

Bob

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



"falconshh" wrote in message
...
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??

Excel-VBA
 

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)


"falconshh" wrote in message
...
the question is:
with no office environment, VBA can be executed ?

"Bob Phillips" wrote:

So what is the question?

--
---
HTH

Bob

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



"falconshh" wrote in message
...
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??