vba code not printing my excel pages correctly

[khalid7977]

Hello,
I have this vba code, its printing my excel data pages each 5 hours, it was working good, but i formatted my pc then got this problem,
the problem is some pdf pages not showing the data completely, its showing data partly.
here is my simple code:
For i = 1 To 57
sheetxx(i).Select
Application.Wait (Now + TimeValue("0:00:05"))
pdffilename = fname2 & "\" & sheetxx(i).Name & ".pdf"
jpegfilename = fname2 & "\" & sheetxx(i).Name & ".jpg"
Shell ("D:\khalid\nircmd.exe savescreenshot " & jpegfilename)
Shell ("D:\khalid\screentopdf.exe " & jpegfilename & " " & pdffilename)
sheetxx(i).Select
sheetxx(i).ChartObjects(1).Activate
For Each objCht In ActiveSheet.ChartObjects
objCht.Chart.Export fname1 & i & ".gif", "GIF"
Next objCht
Next i

Please help me. Thank you.

 

[bobsan42]

It looks like you are making screenshots rather than printing.
so this probably means that your data does not show on the screen completely. So maybe zooming the sheets may help?
Can you show an example of the output and what result you would expect ?

 

[khalid7977]

It looks like you are making screenshots rather than printing.
so this probably means that your data does not show on the screen completely. So maybe zooming the sheets may help?
Can you show an example of the output and what result you would expect ?

Hi
Thank you for your time and help. Here see 2 files. Sometimes the data not shown and sometimes its shown completely. Thank you again for your time.

 

[bobsan42]

Hi
Thank you for your time and help. Here see 2 files. Sometimes the data not shown and sometimes its shown completely. Thank you again for your time.

I see no files here.

 

[khalid7977]

I see no files here.

Sorry, i uploaded them already, i shall do it again.

 

[Joe4]

Sorry, i uploaded them already, i shall do it again.

If you look at your previous two posts in this thread, you can see that there is nothing attached. Actually, you cannot upload files to this site at all, only images.

There is a tool that will allow you to post images in a way that others can copy and download them, formulas included.
MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.