VBA is not printing to PDF correctly

[misterno]

Here is my code

VBA is not printing the correct area instead it is printing C3:X212. (The correct area is "$c$3:$AA$212")

Can someone help?

Please Login or Register  to view this content.

[AlphaFrog]

Can your columns C:AA all fit on one page width? You may have to play with the page margins, zoom to fit, and\or font sizes to get it to fit.

[misterno]

Can your columns C:AA all fit on one page width? You may have to play with the page margins, zoom to fit, and\or font sizes to get it to fit.

I set all margins to zero already

When I looked at the pages to be printed it all seems fine but when it prints to PDF it is out of whack

Here are the pics

http://i.hizliresim.com/5VaM7z.jpg

http://i.hizliresim.com/y46L5k.jpg

http://i.hizliresim.com/2Z68Z2.jpg

[JBeaucaire]

Maybe a little reorganizing:

Please Login or Register  to view this content.

[Kenneth Hobson]

How is it different than the print preview?

To get the right page setup for zoom to fit, record a Print but then cancel the actual print, stop recording, and then view the code.

[misterno]

Maybe a little reorganizing:

Please Login or Register  to view this content.

I ran this 3 times, but it gives me blank pages

[misterno]

How is it different than the print preview?

To get the right page setup for zoom to fit, record a Print but then cancel the actual print, stop recording, and then view the code.

Print preview has the whole area covered whereas the printed PDF is cut off on X column instead of AA

I just saw your recommendation, let me try

EDIT: Here is the code it recorded

Please Login or Register  to view this content.

So how to incorporate this into my VBA?

[JBeaucaire]

Replace the last line of the macro I suggested with that snippet above instead.

[misterno]

Replace the last line of the macro I suggested with that snippet above instead.

I did but the last paragraph reds out so it does not work

Please Login or Register  to view this content.

But if I do this

Please Login or Register  to view this content.

then it just prints and of course I want to save it as PDF

[Kenneth Hobson]

Printto, well prints to your printer. What you want is to export to pdf. You got the PrintTo from recording a macro and printing I guess. I said to cancel printing. You can see the many options set when I set it to Fit All. I doubt that you need all of the options set.

Another area of confusion is the folder name versus the file name. See my comments. I am not sure which is correct.

I have not tested this since I don't have your worksheets.

Please Login or Register  to view this content.

[misterno]

Printto, well prints to your printer. What you want is to export to pdf. You got the PrintTo from recording a macro and printing I guess. I said to cancel printing. You can see the many options set when I set it to Fit All. I doubt that you need all of the options set.

Another area of confusion is the folder name versus the file name. See my comments. I am not sure which is correct.

I have not tested this since I don't have your worksheets.

Please Login or Register  to view this content.

great now I am getting this

http://i.hizliresim.com/ZdXd1o.jpg

EDIT: restarted the pc and now it is working

I need to play around with the margins to make it better though

Can you tell me what made it work this time?

Also I need to insert 2 charts to my PDF located in "New England Balances" tab.

Chart1 and Chart3 are the names and they are located at the right hand side.

How to insert these to my PDF in a seperate page?

[Kenneth Hobson]

Order of PDF pages is governed by the sheet index order. As such, try to do this manually first.

Insert a worksheet for each chart. Set each sheet's print range which encloses the chart(s). Group select the worksheets in consecutive order. Look at Print Preview. Then try a File > SaveAs > PDF.

IF that works, we can make a macro to do it.

If not, things get more complex. Another method would be needed which might require Acrobat (not the reader) or a third party program. One would export each range and chart as a picture file and then merge the picture files and Save to PDF.

If the manual method works, workup a short example file with obfuscated data and attach the file.

[misterno]

Kenneth

Here is the code but it is not working. It is just printing the sheets but not the chart. Can you help?

(I am trying your recommendation now)

Please Login or Register  to view this content.

[misterno]

Here is the code you suggested

So I inserted a line for the chart are (highlighted) but it is not printing at all not even the sheets itself

Please Login or Register  to view this content.

[misterno]

nmxdvxcvcvcv