在 Power Query 中作为筛选行应用的 VBA 字符串 [英] VBA String applied as filtered rows in Power Query

问题描述

有没有办法根据 VBA 记录的 Power Query 的单元格值定义字符串?我试过将字符串设置为

Is there a way to Define a string based on a cell value for a VBA recorded Power Query? I have tried setting the string as

    Dim Test As String
    TestFilter = """" & "Filter" & """"

但#Filtered Rows 无法识别输入，即

But the #Filtered Rows is not recognizing the input I.e

    #""Filtered Rows"" = Table.SelectRows = ([Filter1] = TestFilter)

这不是识别 VBA 中的字符串.非常感谢任何帮助

This is not recognizing the string in VBA. Any help is greatly appreciated

推荐答案

使用 VBA 将变量内容分配给命名范围

Use the VBA to assign the variable contents to a named range

使用该范围名称代替下面的 NamedRangeName

Use that range name in place of NamedRangeName below

#"Filtered Rows" = Table.SelectRows = ([Filter1] = Excel.CurrentWorkbook(){[Name="NamedRangeName"]}[Content]{0}[Column1])

这篇关于在 Power Query 中作为筛选行应用的 VBA 字符串的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！