excel - Converting postscript file to pdf not working -

-

PDF -

The problem is that the process does not detect any contents in the worksheet - how can I 'activate' the content?

-

I have a VBA macro that converts Excel reports in PDF files - I address myself to repeat several workbooks, but when I work in a workbook I do and others do not.

The code is below - I update the four values ​​in each of the respective cell / value for each workbook and I have checked that only one reference is selected in each workbook.

When I run the code, it changes through the loop index index produces pdf with cell and new data. While one of the workbooks is not being made in PDF, I have stepped through the code and it creates a postcript file but it does not convert to PDF. 

  public sub Niryatgraf () Const index = "B55" Const Print = "D55" Const authority Name = "B5" Const filename = "civic culture and community venues performance indicator standings Report 2013 -14 - "Applications. Screenapting = wrong application ShowWindowsInTaskbar = False application.DisplayAlerts = False application .EnableEvents = False Dim set workspace as I like integer as awb = thisWorkbook awb.Worksheets to set Peedifdistiller as dim myPDF myPDF = new Peedifdistiller i = 1 ( " Pin"). Range (total cell) .Value awb.Worksheets ("PIN"). Range (Indexell). Value = idiom strGraphLoc, string strpin = awb.Sheets ("PIN") as string. Category (Authorization Name) Value & amp; "" & Amp; Awb.Worksheets ("PIN") Range ("B6") Value strgraphLoc = awb.path & amp; "/" Dim PSFileName string as a PDFFileName string in the form of PSFileName = strGraphLoc & amp; Filename & amp; Stripin & amp; ".ps" PDFFileName = strGraphLoc & amp; Filename & amp; Stripin & amp; ".pdf" 'PostScript file ABB to Apple range. Print Sheet ("Pin"). Print copies = 1, and = 1, preview = false, Aktivprint in = "Acrobat Distiller" Printtofail: = True, Collette: = True, Protofailnam = PSFileName '.pdf myPDF.FileToPDF PSFileName, PDFFileName, Convert PostScript File "" PSFileName Kill strGraphLoc & amp; Filename & amp; Stripin & amp; ".log" Next I set myPDF = nothing application. Display alter = true app Screen upturning = right app ShowWindowsInTaskbar = True Application.EnableEvents = True End Sub

would be greatly appreciate any help, I can not work for your life because it works for some people and for others No.

I have problem with the workbook, is created a 0kb PostScript file is a text file that says: / P>

%% [Warning: Empty job a PDF file Not created] %% - Byte PostScript language file contains: %%

There is no graphics, so distiller can not convert it into a meaningful PDF file. So, why is PostScript language file 0 bytes long?

The problem has been unsuccessful with printing from the spreadsheet.

Take the VBA out of the problem Try to print the problem spreadsheet through the Excel "Print" menu item. Print on PostScript and non-PostScript printers I suspect that this will also fail.

Diagnose Printing Failure After working "Print" menu item, I suspect that VBA script will also be there.


Comments

Post a Comment

Popular posts from this blog

apache - 504 Gateway Time-out The server didn't respond in time. How to fix it? -

-
Using a form submission on an embedded iframe , the customer downloads a compressed log file Requested. The request was sent to the server, which is the compressed log files, perform some database operations and returns a compressed file. After just 2 minutes, 504 gateway time-out server did not respond timely message on browser net panel How to fix this error? The log files were taking a long time to compress, and timeout was set to 2min The error was fixed by extending the file file: # # timeout: The number of seconds before getting the time out. # # # Timeout 120 timeout 600
Read more

c# - .net WebSocket: CloseOutputAsync vs CloseAsync -

-
We have a working ASP.NET Web API REST service, which is one of the methods of our controller, HTTPTTEX. .) Socket handler code looks something like this ... Public async task socket handler (AspNetWebSocketContext context) {_webSocket = context.WebSocket; ... while (! Cts.IsCancellationRequested) {WebSocketReceiveResult Results = _webSocket.ReceiveAsync (Input Segment, cts.Token) .Result; WebSocketsStateCollusocketState = _webSocket.State; If (result.MessageType == WebSocketMessageType.Close || currentSocketState == WebSocketState.CloseReceived) {// What should I use. CloseAysnc () or. CloseOutputAsync ()? _webSocket.CloseOutputAsync (WebSocketCloseStatus.NormalClosure, "Client Requested", cts.Token). Wait (); } If (currentSocketState == WebSocketState.Open) {...}}} .What is the difference between .CooseAsync () and CloseOutputAysnc ()? I tried both of them and they both seemed to work fine but some difference should be the same they both describe very similar to...
Read more

c++ - How to properly scale qgroupbox title with stylesheet for high resolution display? -

-
I am trying to apply a stylesheet for QGroupBox (QT4.8), which works on the normal screen ( 96 dpi) high resolution screen (Yoga 2 Pro, 3200x1800, 275 dpi, windows 8.1). The following style looks good on the 275 dpi screen, but the top margins on a regular 96 dpi screen are far too big. QGroupBox {border: 1px solid red; Range radius: 7px; Margin-top: 12x; } QGroupBox :: Title {subcontrol-origin: margin; Subcontrol-position: left above; Padding-left: 10px; Padding-right: 10px; } Changing the top-margin has an effect, but I did not get a proper setting which works on both screens. If I shorten the value, the content of the group box overlaps with the title on 275 dpi screen. I was also playing with units "East", "PX", "MX", "PT". Reading the document I would have guessed, "2 X" was the correct solution, which should be scaled with different screen resolutions. Without the stylesheet, the groupbox works well on both screens. ...
Read more