Mod_PublicConst

Option Explicit
Option Base 1

'==================================================
' モジュール名: Mod_PublicConst
' 概要: 全体で共通使用する定数定義
'==================================================

' メインシート: shMain
Public Const ROW_shMAIN_IMPORTPATH As Long = 2
Public Const COL_shMAIN_IMPORTFOLDER As Long = 3  ' C列
Public Const COL_shMAIN_IMPORTFILE As Long = 4    ' D列
Public Const ROW_shMAIN_EXPORTPATH As Long = 4
Public Const COL_shMAIN_EXPORTFOLDER As Long = 3  ' C列
Public Const COL_shMAIN_EXPORTFILE As Long = 4    ' D列
Public Const RNG_shMAIN_EXPORTFOLDER As String = "C4"

' 項目シート: shItems
Public Const ROW_shITM_START      As Long = 2
Public Const COL_shITM_NAME       As Long = 2   'B列

' インポートシート: shImport
Public Const ROW_shIMP_HEADER     As Long = 1
Public Const ROW_shIMP_VALSTART      As Long = 2

' 出力フォーマットシート: shFormat
Public Const ROW_shFMT_VALSTART     As Long = 2
Public Const COL_shFMT_EXPORT     As Long = 12  ' L列

' CSVファイル仕様
Public Const ROW_CSV_HEADER       As Long = 10
Public Const ROW_CSV_START        As Long = 11
Public Const NUM_CSV_ROWS         As Long = 5

' 汎用設定
Public Const C_DATE_FORMAT        As String = "yyyy/mm/dd"