Opening Excel Worksheet - "Object reference not set to an instance of an object."

[xhenxhe]

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.Applicati on
Dim xlBook As Excel.Workbook
Dim xlSheet As Excel.Worksheet

Try
xlApp = CType(CreateObj ect("Excel.Appl ication"), Excel.Applicati on)
Catch ex As Exception
MsgBox("Could not create Excel Application Object: " & ex.Message,
MsgBoxStyle.Cri tical, Title)
Exit Sub
End Try

Try
xlBook = CType(xlApp.Wor kbooks.Open(txt CommonTemplate. Text),
Excel.Workbook)
Catch ex As Exception
MsgBox("Could not create instance of Excel Workbook: " & ex.Message,
MsgBoxStyle.Cri tical, Title)
Exit Sub
End Try

Try
xlSheet = CType(xlBook.Wo rksheets(1), Excel.Worksheet )
Catch ex As Exception
MsgBox("Could not create instance of an Excel Worksheet: " & ex.Message,
MsgBoxStyle.Cri tical, 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

[xhenxhe]

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" <Br*****@discus sions.microsoft .com> wrote in message
news:FC******** *************** ***********@mic rosoft.com...

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.Applicati on
Dim xlBook As Excel.Workbook
Dim xlSheet As Excel.Worksheet

Try
xlApp = CType(CreateObj ect("Excel.Appl ication"), Excel.Applicati on)
Catch ex As Exception
MsgBox("Could not create Excel Application Object: " & ex.Message,
MsgBoxStyle.Cri tical, Title)
Exit Sub
End Try

Try
xlBook = CType(xlApp.Wor kbooks.Open(txt CommonTemplate. Text),
Excel.Workbook)
Catch ex As Exception
MsgBox("Could not create instance of Excel Workbook: " & ex.Message,
MsgBoxStyle.Cri tical, Title)
Exit Sub
End Try

Try
xlSheet = CType(xlBook.Wo rksheets(1), Excel.Worksheet )
Catch ex As Exception
MsgBox("Could not create instance of an Excel Worksheet: " & ex.Message, MsgBoxStyle.Cri tical, 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

[Dennis]

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

xlsheet.Activat e

--
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.Applicati on
Dim xlBook As Excel.Workbook
Dim xlSheet As Excel.Worksheet

Try
xlApp = CType(CreateObj ect("Excel.Appl ication"), Excel.Applicati on)
Catch ex As Exception
MsgBox("Could not create Excel Application Object: " & ex.Message,
MsgBoxStyle.Cri tical, Title)
Exit Sub
End Try

Try
xlBook = CType(xlApp.Wor kbooks.Open(txt CommonTemplate. Text),
Excel.Workbook)
Catch ex As Exception
MsgBox("Could not create instance of Excel Workbook: " & ex.Message,
MsgBoxStyle.Cri tical, Title)
Exit Sub
End Try

Try
xlSheet = CType(xlBook.Wo rksheets(1), Excel.Worksheet )
Catch ex As Exception
MsgBox("Could not create instance of an Excel Worksheet: " & ex.Message,
MsgBoxStyle.Cri tical, 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