Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

LOOP THRU CUST# LIST BOX AND PRINT SHEET

Want to automatically select each customer# in a LIST BOX and PRINT SHEET.

i.e. Select 1st Customer# and Print Sheet;

Select 2nd Customer# and Print Sheet;

etc.

How is this done? > MACRO?

11 Replies
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP


ben6711 wrote:on Document Open


I think you'll have to do the printing in the Document Open macro. That makes sense to me.

Also you should probably have:

ActiveDocument.GetApplication.WaitForIdle

before the print call.

-Rob

Not applicable
Author

ActiveDocument.GetApplication.WaitForIdle did the trick!

-I use a PDF Print driver ("ScanSoft PDF Create" from Scan Soft PDF CONVERTER)

to create a PDF document when I "print" each sheet.

Can the passed variable appear as true text which Acrobat Reader can search on?

Currently generated PDF's are apparently graphics and Acrobat Reader has nothing to search on.

(Yes, I really need to do this)