Excel-VBA

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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??
 
So what is the question?

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
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)
 
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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top