Question

vba问题ThisWorkbook.Path & "\" & CStr(Trim(Sheets(sheet1).Range("A1").Value)) & "_setpoints.csv"

Function DeleteCaseSetpointsFile() As Boolean
'''!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
''' !
'''Description: !
''' This function is used to delete the case setpoint file. !
''' !
'''Parameter : !
''' !
'''ReturnValue: !
'''!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

DeleteCaseSetpointsFile = False

sSetpointsFileNameWithPath = ThisWorkbook.Path & "\" & CStr(Trim(Sheets(sSetpoints).Range("E2").Value)) & "_setpoints.csv" 这句话什么意思，主要是"_setpoints.csv" 这个什么意思，新手求解释

If Dir(sSetpointsFileNameWithPath) <> "" Then

On Error GoTo FileDeleteError:

Kill sSetpointsFileNameWithPath ' deletes the file if it exists

End If

DeleteCaseSetpointsFile = True

Exit Function

FileDeleteError:

MsgBox Sheets(sSetpoints).Range("E2").Value & "_setpoints.csv " & "File is not available for writing", vbInformation, ThisWorkbook.Name

End Function

Answer 1

"_setpoints.csv" 就是文件名的后半部分啊。

ThisWorkbook.Path & "\" & CStr(Trim(Sheets(sSetpoints).Range("E2").Value)) & "_setpoints.csv"
首先“&”符号是连接符，用语字符串的连接。
这个文件的全路径就是 “当前Excel所在路径 + sSetpoints工作表的E2的值_setpoints.csv"

sSetpoints是个变量，比如sSetpoints等于Sheet1吧，而Sheet1的E2的值是”Point1“
那个这个文件名就是”Point1_setpoints.csv“。

Answer 2

啊的撒发生大噶味儿

Answer 3

是一个文件的名字