子名称上的VBA“无效限定符”错误

'Get file path and put it in the proper cell
Sub GetFilePath()
    Dim DialogBox As FileDialog
    Dim path As String
    Set DialogBox = Application.FileDialog(msoFileDialogFilePicker)
    DialogBox.Title = "Select quarterly report for " & Range("A" & ActiveCell.Row) & _
        " " & Range("B" & ActiveCell.Row)
    DialogBox.Filters.Clear
    DialogBox.Show
    If DialogBox.SelectedItems.Count = 1 Then
        path = DialogBox.SelectedItems(1)

子名称上的VBA“无效限定符”错误 内容来源于 Stack Overflow，遵循 CC BY-SA 4.0 许可协议进行翻译与使用。IT领域专用引擎提供翻译支持 腾讯云小微IT领域专用引擎提供翻译支持