VB.NET - Excel公式

Question

嗨，im试图用以下方法编程地将一个公式插入到单元格中：

        With wbXl.Worksheets("Sheet2")
        .Cells(9, 2).Formula = "=SUMIFS(Running!C2:C999999,Running!B2:B999999,">=01/10/2014 00:00:00",Running!B2:B999999,"<=01/10/2014 23:59:59")"
    End With

问题是，“在公式中玩havok与vb说语法错误。

我怎样才能解决这个问题，任何帮助都是很棒的:)

非常感谢，皮特

Answer 1

使用两个双引号来转义它们。(基本上除了第一个和最后一个“让剩下的都是”)

.Cells(9, 2).Formula = "=SUMIFS(Running!C2:C999999,
Running!B2:B999999,"">=01/10/2014 00:00:00"",Running!B2:B999999,
""<=01/10/2014 23:59:59"")"

这将在单元格中产生以下公式

=SUMIFS(Running!C2:C999999,Running!B2:B999999,">=01/10/2014 00:00:00",Running!B2:B999999,"<=01/10/2014 23:59:59")