Why is printform1 not working?

Question

0.00/5 (No votes)

See more:

My application was working fine. However, I needed to add some refinements which had nothing to do with the printing.
But now the code which printed a pdf copy of my EXCEL worksheet does not now work.
The code is

PrintForm1.PrinterSettings.PrinterName = "Microsoft Print to PDF"
        PrintForm1.PrintAction = Printing.PrintAction.PrintToPrinter

        If PrintForm1.PrinterSettings.IsValid Then
            PrinterName = PrintForm1.PrinterSettings.PrinterName
            oSheet.PrintOut(From:=1, To:=1, Copies:=1, ActivePrinter:=PrinterName, Collate:=True, Preview:=True)

I get this error message associated to the first line.
"System.NullReferenceException: 'Object reference not set to an instance of an object.'

MatchManagementApplication_2.InputForm.PrintForm1.get returned Nothing.
Any help greatly appreciated.
"

What I have tried:

I have Imported Microsoft.VisualBasic.PowerPacks.Printing but the code stated it was not required.
Changed to Microsoft.VisualBasic.PowerPacks then a new error message came up on the second line of code, stating Error BC30456 'PrintAction' is not a member of 'Microsoft.VisualBasic.PowerPacks.Printing'.
Commented out the second line of code but the first line still fails when the code is run.

Posted 27-Nov-17 10:36am

Dave the Golfer

Updated 27-Nov-17 22:38pm

Add a Solution

1 solution

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)

Richard MacCutchan · Accepted Answer · 2017-11-27T22:38:00

Solution 1

System.NullReferenceException is one of the most common errors we see reported here. It means that you are trying to use an object reference that has not been initialised. The only way to find out where and why is to use your debugger to step through your code.

Posted 27-Nov-17 22:38pm

Richard MacCutchan