I don't some Excel automation. I've created a program that opens and Excel
template and inputs information to it. It runs great on my machine. When I
build and deploy I have a user that keep getting the error message: "Object
reference not set to an instance of an object."

Here is the code that generates the message:
Dim xlApp As Excel.Application
Dim xlBook As Excel.Workbook
Dim xlSheet As Excel.Worksheet

Try
xlApp = CType(CreateObject("Excel.Application"), Excel.Application)
Catch ex As Exception
MsgBox("Could not create Excel Application Object: " & ex.Message,
MsgBoxStyle.Critical, Title)
Exit Sub
End Try

Try
xlBook = CType(xlApp.Workbooks.Open(txtCommonTemplate.Text),
Excel.Workbook)
Catch ex As Exception
MsgBox("Could not create instance of Excel Workbook: " & ex.Message,
MsgBoxStyle.Critical, Title)
Exit Sub
End Try

Try
xlSheet = CType(xlBook.Worksheets(1), Excel.Worksheet)
Catch ex As Exception
MsgBox("Could not create instance of an Excel Worksheet: " & ex.Message,
MsgBoxStyle.Critical, Title)
Exit Sub
End Try

====

It is the second Try/Catch that displays the message - trying to open the
worksheet.

I've tried different variants of this code (new instead of ctype) which all
product the same results.

The user having problems is running office 2000. I'm using Office 2002. I'm
assuming this is the problem. Does anyone have a solution (other than me
downgrading or the user upgrading)?

Thanks,
Dustin

--
Dustin
--
http://www.LDSPDA.com
http://www.Shiblon.com

Hi Brian, I had just read many of your posts here
(http://www.devdex.com/vb/message.asp...4362847&page=2) before posting
this message...

It appears I'm using version 10. Where would I obtain other versions?

Thanks,
D

--
Dustin
--
http://www.LDSPDA.com
http://www.Shiblon.com

"BrianDH" <(E-Mail Removed)> wrote in message
news:FCB64BE8-2427-483C-B4C7-(E-Mail Removed)...
> what version of Excel & Office dll LIB's are you using? 9, 11 ?
> you may need to add addtional refferences to other objects to run both 200
& 2002.
>
> B
>
> "xhenxhe" wrote:
>
> > I don't some Excel automation. I've created a program that opens and
Excel
> > template and inputs information to it. It runs great on my machine. When
I
> > build and deploy I have a user that keep getting the error message:
"Object
> > reference not set to an instance of an object."
> >
> > Here is the code that generates the message:
> > Dim xlApp As Excel.Application
> > Dim xlBook As Excel.Workbook
> > Dim xlSheet As Excel.Worksheet
> >
> > Try
> > xlApp = CType(CreateObject("Excel.Application"), Excel.Application)
> > Catch ex As Exception
> > MsgBox("Could not create Excel Application Object: " & ex.Message,
> > MsgBoxStyle.Critical, Title)
> > Exit Sub
> > End Try
> >
> > Try
> > xlBook = CType(xlApp.Workbooks.Open(txtCommonTemplate.Text),
> > Excel.Workbook)
> > Catch ex As Exception
> > MsgBox("Could not create instance of Excel Workbook: " & ex.Message,
> > MsgBoxStyle.Critical, Title)
> > Exit Sub
> > End Try
> >
> > Try
> > xlSheet = CType(xlBook.Worksheets(1), Excel.Worksheet)
> > Catch ex As Exception
> > MsgBox("Could not create instance of an Excel Worksheet: " &
ex.Message,
> > MsgBoxStyle.Critical, Title)
> > Exit Sub
> > End Try
> >
> > ====
> >
> > It is the second Try/Catch that displays the message - trying to open
the
> > worksheet.
> >
> > I've tried different variants of this code (new instead of ctype) which
all
> > product the same results.
> >
> > The user having problems is running office 2000. I'm using Office 2002.
I'm
> > assuming this is the problem. Does anyone have a solution (other than me
> > downgrading or the user upgrading)?
> >
> > Thanks,
> > Dustin
> >
> > --
> > Dustin
> > --
> > http://www.LDSPDA.com
> > http://www.Shiblon.com
> >
> >
> >

For some statements to work with Excel, you have to make the worksheet active;

xlsheet.Activate

--
Dennis in Houston


"xhenxhe" wrote:

> I don't some Excel automation. I've created a program that opens and Excel
> template and inputs information to it. It runs great on my machine. When I
> build and deploy I have a user that keep getting the error message: "Object
> reference not set to an instance of an object."
>
> Here is the code that generates the message:
> Dim xlApp As Excel.Application
> Dim xlBook As Excel.Workbook
> Dim xlSheet As Excel.Worksheet
>
> Try
> xlApp = CType(CreateObject("Excel.Application"), Excel.Application)
> Catch ex As Exception
> MsgBox("Could not create Excel Application Object: " & ex.Message,
> MsgBoxStyle.Critical, Title)
> Exit Sub
> End Try
>
> Try
> xlBook = CType(xlApp.Workbooks.Open(txtCommonTemplate.Text),
> Excel.Workbook)
> Catch ex As Exception
> MsgBox("Could not create instance of Excel Workbook: " & ex.Message,
> MsgBoxStyle.Critical, Title)
> Exit Sub
> End Try
>
> Try
> xlSheet = CType(xlBook.Worksheets(1), Excel.Worksheet)
> Catch ex As Exception
> MsgBox("Could not create instance of an Excel Worksheet: " & ex.Message,
> MsgBoxStyle.Critical, Title)
> Exit Sub
> End Try
>
> ====
>
> It is the second Try/Catch that displays the message - trying to open the
> worksheet.
>
> I've tried different variants of this code (new instead of ctype) which all
> product the same results.
>
> The user having problems is running office 2000. I'm using Office 2002. I'm
> assuming this is the problem. Does anyone have a solution (other than me
> downgrading or the user upgrading)?
>
> Thanks,
> Dustin
>
> --
> Dustin
> --
> http://www.LDSPDA.com
> http://www.Shiblon.com
>
>
>