Package and Install

[Jumpercables]

So I am trying to make an installer for my program. I am using VBInstaller downloaded from Microsoft. But I am not sure how to add my dependencies or where to find them.

Example:

Neither a merge module nor dependacy information could be found for c:\program files\microsoft office\office 10\execl.exe

One or more files in MDAC.MSM have different versions that those installed on this machine
...

How do I add those dependancies or am I doing these wrong? Did I go about the procedure correct? I just loaded VBInstaller and browesd to my project. Is there an easier way?


Thanks In Adance!

[RobDog888]

Its because Excel is not redistributable. Your target systems will need their own license for Excel.

[Jumpercables]

So as long as Excel is installed on the other computer it will work fine?

What about the other dependencies where do I find them?

[RobDog888]

Which installer is it? MSI 1.1? It depends on what your using in your app.
Are you targeting Excel XP only or are you trying to support all versions of Excel?

[Jumpercables]

Version 1.1 and I would like to target all excel above 2002

[RobDog888]

Since you are targeting more then one version of Excel then you need to modify your program to Late Bind with Excel. This means to remove the Excel reference and declare your Excel variables as Object. Then upon start of your app you need to determine the version of Excel that installed, if any, and handle appropriately.

[Jumpercables]

I am using all objects however I am using this statement to locate cells and its the only reason I have the excel reference.

'Finds the location of a cell that contains the string provide. 
'If found returns the cell number location if not found returns -1
Private Function FindCellLocation(Sheet As Object, Look As String) As Integer
    Dim nCol As Integer
       For nCol = 1 To Sheet.Cells.SpecialCells(xlCellTypeLastCell).Column
        If Sheet.Cells(4, nCol).Value = Look Then
            FindCellLocation = nCol
            Exit For
        End If
        FindCellLocation = -1
    Next nCol
End Function

Is there any way to preform this section without the reference? If not then I know this program works on the platform it was designed to run on. So I could technically keep the reference. In that case how would I add the execl reference? Or is that not needed if the current version of excel works with the program its running on.

And how do you add the other dependanciess?