I am generating multiple packing lists within excel (on single sheet*), my boss would like those to be printed as PDF. Anyone knows if I can VBa /macro to print within excel?
The reason why I can't do it manually because single packing list will be generated one at a time, then send to PDF creator to print as file, then move on to next one.. I have successfully created this with another pdf software ("PDFCreator") but the problem is when I copy & paste the text within the pdf file, the character turns into weird symbols.
Note: on single sheet*
Processes: create single packing list on sheet "X" > print as PDF > create next single packing list > print as PDF till end of orders.