Printing PDF file as per the counts specified in Excel sheet

N

nitkot

New Member
Joined
May 2, 2023
Messages
22
Office Version
  1. 2019
Platform
  1. Windows
  2. Mobile
  3. Web
We are non-profit organization, which is sending the question papers of religious exam to various schools based on their enrollment of levels.

We need one code, which can print/export to combined PDF based on the parameters given in the excel sheet.

Please check the attached excel sheet for parameters. At break of every school change, system can print one banner page with school name.
 

Attachments

  • Screenshot_6.png
    Screenshot_6.png
    24.5 KB · Views: 16
Sort by date Sort by votes
nitkot said:
getting this error which is attached herewith.
Click to expand...

What is the value of PDFfullName? Does the file exist?

Open a command prompt and copy and paste the last line from the VBA Immediate Window. This is a PDFtk command to create dump_data.txt in the same folder as PDFfullName. Does the command work? Is dump_data.txt created?
 
Upvote 0

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.
You must log in or register to reply here.

Similar threads

N
  • Question Question
VBA to add title from formula to a save as name
Replies
0
Views
208
NKUNZI
N
S
  • Question Question
Print out linked .pdf files using VBA
Replies
5
Views
523
RoryA
RoryA
V
  • Question Question
Print to PDF in VBA
Replies
0
Views
559
visheshkotha
V
D
  • Question Question
Print Multiple invoices in one PDF File
Replies
1
Views
415
John_w
J
A
  • Question Question
VBA for setting up the printing pages per sheet
Replies
0
Views
695
Aurum1
A

Forum statistics

Threads
1,226,065
Messages
6,188,678
Members
453,490
Latest member
amru

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top