【摘要】 为了实现Excel表中单条记录的自定义格式输出,笔者在工作簿中附加了一个打印用表,用以制作报表模板。再采用VBA编程,实现了原始表中单条记录到自定义格式报表的数据传递与输出。与Office中Word和Excel相结合的邮件合并方法相比较,有使用灵活和适用范围广的特点。更多还原

【Abstract】 To print a single record of Excel worksheets by self-defining form,first auther adds a sheet in the end of the workbook to make report form template,and then realizes the transmission and output of the data from a single record in the activesheet to the selfdefining from by VBA.The method is compared to the mail amalgamation with Word and Excel in Office,there are the characteristics of extensive suitable range and flexible usage.更多还原