>I did as you suggested. I changed my code from this:
>
> Dim xlApp As Excel.Application
> Dim xlBook As Excel.Workbook
> Dim xlSheet As Excel.Worksheet
> Set xlApp = CreateObject("Excel.Application")
> Set xlBook = xlApp.Workbooks.Add
> Set xlSheet = xlBook.Worksheets(1)
>
>To this:
>
> Dim xlApp As Object
> Dim xlBook As Excel.Workbook
> Dim xlSheet As Excel.Worksheet
> Set xlApp = CreateObject("Excel.Application")
> Set xlBook = xlApp.Workbooks.Add
> Set xlSheet = xlBook.Worksheets(1)
>
>I compiled my app to an exe file and ran it on a pc that has office97 installed on it. I get the following error:
>
>Runtime error '429':
>ActiveX component can't create object
>
>Any other ideas?
>
>>
>>-Remove the reference to Excel.
>>-Declare as object (Dim xlApp as Object).
>>-Instantiate your object (Set xlApp = CreateObject("Excel.Application"))


Have you removed the reference to Excel (from Project->References)?