在模板工作表中做好单证模板，模板中红色字体为动态数据，在数据表中整理好发票中的动态数据。单击“”生成单证“”，VBA程序会自动以发票号为文件名批量生成pdf单证(The template is done in the template worksheet. The red font in the template is dynamic data, and the dynamic data in the invoice is arranged in the data table. Click "" to generate the document "", and the VBA program automatically generates PDF documents with the invoice number for the filename.)