我从下拉菜单中获得一个客户名称,然后使用该值查询一个 Excel 电子表格,但是名称可能包含一个单引号(例如:Adam's Meat)。这会破坏我的应用程序,那么我如何使用包含单引号的变量进行查询?
Private Sub cboCompany_Change()
Dim customerName As String
customerName = cboCompany.Value
rsT.Open "SELECT Customer, Postcode, Address1, Address2, State, Country FROM Customers WHERE Customer = '" & customerName & "'", cn, adOpenStatic