object reference not set to an instance an object

Question

0.00/5 (No votes)

See more:

Hi,

I have an vb.net application which interacts with an excel file and gets the data from it and write them into an text file. When i run my project code, it is running successfully and writes the data into a text file from excel.

But when i run the EXE file directly, it is showing an error, "object reference not set to an instance an object". The same error occurred when i prepare and run the setup of the project.

Please can anyone share your ideas to troubleshoot this issue.

Thanks,
Sivakumar.M.

Posted 19-Sep-10 17:34pm

sivakumar.mariappan

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Abhinav S · Answer 1 · 2010-09-19T18:36:00

Solution 1

Most probably, the file path to the excel may be incorrect.
Check if this is working correctly.

Posted 19-Sep-10 18:36pm

Abhinav S

Hiren solanki · Answer 2 · 2010-09-19T19:16:00

Solution 2

object reference not set to an instance an object
This Occurs probably when object is not initialized or Having null value.

Check this for all your objects in all the way
Which may Solve your Problem.

Posted 19-Sep-10 19:16pm

Hiren solanki

v2

Simon_Whale · Answer 3 · 2010-09-19T22:17:00

Solution 3

to Further Abhinav's answer also check

1. Excel is installed on the machine and referenced properly
2. the path to the excel file that you are extracting data from is correctly setup

Posted 19-Sep-10 22:17pm

Simon_Whale

Updated 19-Sep-10 22:18pm

v2