Queries.Add method (Excel)

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.