Solved

Creating a PDF File

Posted on 2013-12-03
5
318 Views
Last Modified: 2013-12-05
We are writing a program for ach transactions in our erp software. We have created a word template which will print a summary of the transaction. We also want the word template to be in pdf format. I have a print button with some test code that creates the pdf. The code works to a point but what is happening is that adobe reader will open and stays open in the task bar. It does not close automatically. If someone could help that would be great. Below is my test code:

                The “CreateNoWindow” keeps the Adobe window from showing, but it’s still in the Taksbar tray.


For x = 1 To 1
strVendor = "1070"
Dim arrFile = "C:\Apps\86\PDFs\Remit_1140_66482_12022013_12022013135501_1.pdf"
            Dim startInfo As New ProcessStartInfo
            startInfo.FileName = strFile
            startInfo.CreateNoWindow = True
            startInfo.Verb = "print"
            startInfo.Arguments = ""
            startInfo.UseShellExecute = True

            startInfo.CreateNoWindow = False

            Dim reportPrint As Process = New Process
            reportPrint.StartInfo = startInfo
            reportPrint.Start()
            reportPrint.CloseMainWindow()
            reportPrint.Close()
       Next
0
Comment
Question by:tmaususer
  • 3
  • 2
5 Comments
 

Author Comment

by:tmaususer
Comment Utility
Sorry I should have added. What I am looking for is once the print button in pressed, the pdf prints and adobe closes automatically and not stay open in the task bar
0
 

Author Comment

by:tmaususer
Comment Utility
I'm going to up the points in the hopes for a response.
0
 
LVL 23

Accepted Solution

by:
Michael74 earned 500 total points
Comment Utility
Add

reportPrint.Kill();

after

reportPrint.Close()

Michael
0
 

Author Comment

by:tmaususer
Comment Utility
Michael,

That works but because it is in a loop after the kill process it does not restart (due to the loop) how would I get this to restart? Does that make sense?
0
 
LVL 23

Expert Comment

by:Michael74
Comment Utility
I am not sure what you are after. The loop only runs once in your code ie

for x = 1 to 1

If you are creating multiple pdf's you should be able to create and dispose of the process object for each run of the code. If you need access to the process outside of the loop declare the reportprint process outside of the loop and then kill it as required.

If I have missed the point please advise

Michael
0

Featured Post

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

More often than not, we developers are confronted with a need: a need to make some kind of magic happen via code. Whether it is for a client, for the boss, or for our own personal projects, the need must be satisfied. Most of the time, the Framework…
Parsing a CSV file is a task that we are confronted with regularly, and although there are a vast number of means to do this, as a newbie, the field can be confusing and the tools can seem complex. A simple solution to parsing a customized CSV fi…
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now