ExcelVBA 目次 - ray88’s diary
■configプロシージャ
Option Explicit 'MainシートのUiPathログファイルパスと結果出力先フォルダパスの記載箇所 Public Const strLogFilePathCell As String = "C3" Public Const strOutputFolderPathCell As String = "C5" '結果ファイルの値出力先の列 Public Const intDateTimeCol As Integer = 1 Public Const intMessageCol As Integer = 2 Public Const intLevelCol As Integer = 3 Public Const intLogTypeCol As Integer = 4 Public Const intTimeStampCol As Integer = 5 Public Const intFingerprintCol As Integer = 6 Public Const intWinIdCol As Integer = 7 Public Const intMachineNameCol As Integer = 8 Public Const intProcessNameCol As Integer = 9 Public Const intProcessVersionCol As Integer = 10 Public Const intJobIdCol As Integer = 11 Public Const intRobotNameCol As Integer = 12 Public Const intMachineIdCol As Integer = 13 Public Const intTotalExecutionTimeInSecondsCol As Integer = 14 Public Const intTotalExecutionTimeCol As Integer = 15 Public Const intFileNameCol As Integer = 16 '配列番号12以降の項目名チェック用変数 Public strItemName As String Public strItemName As String '配列の文字列一時格納用 Public strTemp As String '各項目の値格納用変数 Public strDate As String Public strMessage As String Public strLevel As String Public strLogType As String Public strTimeStamp As String Public strFingerPrint As String Public strWinId As String Public strMachineName As String Public strProcessName As String Public strProcessVersion As String Public strJobId As String Public strRobotName As String Public strMachineId As String Public strTotalExecutionTimeInSeconds As String Public strTotalExecutionTime As String Public strFileName As String