能去掉字符串中特定内容吗？

[7kxa]

比如把文件名的后缀去掉。

[liul17]

Private Sub Command1_Click()
Dim s As String
Dim sOk As String

s = "abc.xls"
sOk = Left(s, InStr(s, ".") - 1)
MsgBox sOk

End Sub

[danielinbiti]

private sub command1_click()
dim str1() as string
str1=split(文件名,".")
print str1(0)
end sub

[lxqlogo0]

完全可以啊，left,instr配合用就行了

[射天狼]

Dim s As String

s = "C:\aa.txt"
s = Left(s, Len(s) - 4)
MsgBox s

[longyangyang]

用split
和left
都可以