VBA批量生成word(如offer)
Excel里面有客户的名字、身份证、性别、手机号,通过批量更新offer的这4个变量批量生成offer。VBA代码如下: Sub CreateWord() Dim mypath, Newname, i, XB, wApp mypath = ThisWorkbook.Path & “\” For i = 2 To [a1048576].End(xlUp).Row Newname...