请教贴吧里的高手,如何用excel VBA实现如下效果?

2025-03-01 00:25:15
推荐回答(1个)
回答1:

Set dalo = Application.FileDialog(msoFileDialogOpen)
    With dalo
        .Title = tit
        .AllowMultiSelect = False
        .Filters.Clear
        .Filters.Add f_disc, f_str
        If .Show = 0 Then
            findpath = "0"
            Exit Function
        Else
            findpath = .SelectedItems(1)
        End If
    End With

用Application.FileDialog() 对象试试