|
楼主 |
发表于 2021-9-23 13:37
|
显示全部楼层
我的怎么有些代码是乱码的,是不是Excel版本问题,我现在用的是2016版本
For Each Key In d.keys
Sheet2.Copy after:=Sheets(Sheets.Count): ActiveSheet.Name = Key
[f4] = Key: [c4] = Sheet1.Range("A2")
s = Split(d(Key), ","): [i4] = s(1): [k4] = s(0)
sql = "select 絪絏,嘿,采畖,砏腹,虫,龟祇计秖,虫基,肂,称爹 from [綪扳癘魁$] where 砯ら戳 = #" & Key & "#" |
|