הערה
הגישה לדף זה מחייבת הרשאה. באפשרותך לנסות להיכנס או לשנות מדריכי כתובות.
הגישה לדף זה מחייבת הרשאה. באפשרותך לנסות לשנות מדריכי כתובות.
Adds a new WorkbookQuery object to the Queries collection.
Syntax
expression.Add (Name, Formula, Description)
expression A variable that represents a Queries object.
Parameters
| Name | Required/Optional | Data type | Description |
|---|---|---|---|
| Name | Required | String | The name of the query. |
| Formula | Required | String | The Power Query M formula for the new query. |
| Description | Optional | Variant | The description of the query. |
Return value
WorkbookQuery
Example
The following example shows how to add a query to a workbook from an existing CSV file.
Dim myConnection As WorkbookConnection
Dim mFormula As String
mFormula = _
"let Source = Csv.Document(File.Contents(""C:\data.txt""),null,""#(tab)"",null,1252) in Source"
query1 = ActiveWorkbook.Queries.Add("query1", mFormula)
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.