Automation Of Excel/word Question

[kleinma]

If users here have office installed on their computers.. do I need to distribute any additional files if I add automation of excel or word to my app?

[Hack]

I think you need to distribute the OLB files that contain the references you've made to Word or Excel, but your installer should pick these up. I base this on the fact that the installer I use (Wise) always picks these up as dependancy files.

[kleinma]

Originally posted by Hack
I think you need to distribute the OLB files that contain the references you've made to Word or Excel, but your installer should pick these up. I base this on the fact that the installer I use (Wise) always picks these up as dependancy files.

well it is to add to my app that is already out there... but let me ask you this... if you didn't have office on your system that you had VB on, you wouldn't be able to set a reference to word, excel, etc.. right?? so by installing office, isn't that when those files are put on your computer and registered... so if they all have office then they should have the files right??

I am not doubting you.. just trying to find out for sure before I bother writing this code out...

because lets say you install office (but not VB) you could set a reference to excel via access VBA right???

[Hack]

Originally posted by kleinma
because lets say you install office (but not VB) you could set a reference to excel via access VBA right???

Theoretically, that sounds correct. As I said, my installer always picks those up, so I made the assumption that they needed to be installed.

The quick way to find out would be to go to a machine that has Office installed, but no VB apps, and check to see if those OLB files are there.

[Muddy]

Originally posted by kleinma


well it is to add to my app that is already out there... but let me ask you this... if you didn't have office on your system that you had VB on, you wouldn't be able to set a reference to word, excel, etc.. right?? so by installing office, isn't that when those files are put on your computer and registered... so if they all have office then they should have the files right??

I am not doubting you.. just trying to find out for sure before I bother writing this code out...

because lets say you install office (but not VB) you could set a reference to excel via access VBA right???

I wonder if the possibility of office/windows being installed in alternate locations would be the only reason to have to include these files???

[kleinma]

well i would assume that lets say your app automates excel on a computer that does not have access installed... you would need to include the dependecy... but on a computer that does have it installed (same version and everything) you probably don't need the files.. that is what I am going to bank on.. I will test it and see what happens... I noticed those files are in the office directory and not the VB one anyway.. so I assume they def are part of the office installation..

[Muddy]

Originally posted by kleinma
well i would assume that lets say your app automates excel on a computer that does not have access installed...

if you are automating excel, why would you care whether or not Access is installed?

Only requirement is that User MUST have the application that you are automating installed.

or am i just completely misunderstanding (again) ...