VBA sql调用ADODB,怎样把activecell的值传递到select语句中?

2024-12-21 09:57:24
推荐回答(1个)
回答1:

Sql = "select a.姓名,avg(a.得分) from [数据$] a where a.姓名 = " &ActiveCell.value &" group by a.姓名"