updsv7/vba
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity

Commit Graph

  • a09be7b27b 更新 vba_code_common.txt simple321vip 2026-04-13 09:24:30 +00:00
  • eb36f2499d Remove BuildCSVContent from common module updsv7 2026-04-13 18:23:27 +09:00
  • c9844a6cfe Fix common module and simplify Z1 export updsv7 2026-04-13 18:21:42 +09:00
  • 9338e4adbf Update Z1 export to use common functions updsv7 2026-04-13 18:19:37 +09:00
  • aa1af0c409 Update Z1 to use common functions updsv7 2026-04-13 18:16:57 +09:00
  • e282184fa5 Add common file selection and CSV reading functions updsv7 2026-04-13 18:15:54 +09:00
  • d4886e873c Add common VBA module for CSV import/export updsv7 2026-04-13 18:04:55 +09:00
  • f0d8f2895d Fix remaining function name updsv7 2026-04-13 17:58:56 +09:00
  • 3bb9405c3e Fix function name assignments updsv7 2026-04-13 17:56:30 +09:00
  • 84e9e3f864 Fix double prefix updsv7 2026-04-13 17:55:23 +09:00
  • e984b2581f Fix remaining function calls updsv7 2026-04-13 17:53:45 +09:00
  • b5a8734c80 Update macro calls to Z1_ updsv7 2026-04-13 17:51:57 +09:00
  • bd045a58ae Rename all macros to Z1_ updsv7 2026-04-13 17:50:10 +09:00
  • 5272fa60dc Fix import column mapping and error column updsv7 2026-04-13 17:45:57 +09:00
  • e7cfa66995 Remove extra blank lines at start updsv7 2026-04-13 17:44:31 +09:00
  • 2461379836 Fix compilation errors updsv7 2026-04-13 17:42:11 +09:00
  • 2327612115 Clean up remaining code updsv7 2026-04-13 17:39:44 +09:00
  • f5027b50bb Remove old column mapping code updsv7 2026-04-13 17:37:55 +09:00
  • fd70fb4f8d Z1 CSV import - validate all rows first, map CSV 1-7 to C-I updsv7 2026-04-13 17:34:39 +09:00
  • 6f8f5a084d Z1 CSV import - validate 7 columns, no header updsv7 2026-04-13 17:32:41 +09:00
  • 887f28b05e Update Z1 validation - D,E required within 80 chars, F,G,I optional within 80 chars, H optional 0 or 1 updsv7 2026-04-13 17:25:38 +09:00
  • ca9479ca2e Update Z1 validation - C column must be 3-digit alphanumeric, error in column B updsv7 2026-04-13 17:23:41 +09:00
  • fbb814653e Simplify vba_code_kotsu_master - keep only Import, Export, Validate updsv7 2026-04-13 17:18:49 +09:00
  • 5dfb10ec4a Add vba_code_kotsu_master for Z1 sheet updsv7 2026-04-13 17:14:43 +09:00
  • 01b5dadb2b 更新 vba_code_kukan_detail_master.txt simple321vip 2026-04-13 08:10:05 +00:00
  • 1746dc4b57 Fix compilation errors updsv7 2026-04-13 17:04:04 +09:00
  • 07f7a916d0 更新 vba_code_kukan_detail_master.txt simple321vip 2026-04-13 08:02:05 +00:00
  • d18a7f40f4 Remove G column dropdown logic updsv7 2026-04-13 17:00:44 +09:00
  • 94df0987d5 Fix column mapping in FillFromKukanMaster updsv7 2026-04-13 16:58:03 +09:00
  • 4793431434 Add G and N column fill from Kukan_Master updsv7 2026-04-13 16:56:54 +09:00
  • b6d6101a7c Split E column into E and F updsv7 2026-04-13 16:55:21 +09:00
  • ab0871edf9 Change error column to S (19) updsv7 2026-04-13 16:48:08 +09:00
  • 014a585396 Update CSV columns to I-R (was G-P) updsv7 2026-04-13 16:46:20 +09:00
  • 9aefa61754 Change duplicate check to GH only updsv7 2026-04-13 16:06:04 +09:00
  • 9343709420 Remove numeric check for I column updsv7 2026-04-13 15:57:51 +09:00
  • aab3708a22 Remove redundant GHI empty check updsv7 2026-04-13 15:56:22 +09:00
  • d71ac70677 Add G,H,I required check in validateDetailData updsv7 2026-04-13 15:52:59 +09:00
  • 40a4e62f3f Get header from row 5 updsv7 2026-04-13 15:39:25 +09:00
  • 764fe7516d Revert "Write header separately to avoid encoding issue" updsv7 2026-04-13 15:33:06 +09:00
  • ff37edcc53 Write header separately to avoid encoding issue updsv7 2026-04-13 15:31:10 +09:00
  • a67dbc66ae Fix row count message updsv7 2026-04-13 15:24:37 +09:00
  • fa7e2949ac Fix row count message updsv7 2026-04-13 15:23:31 +09:00
  • d89c921d23 Remove debug code updsv7 2026-04-13 15:21:53 +09:00
  • 6c6b49b919 Trim trailing newlines before write updsv7 2026-04-13 15:19:22 +09:00
  • 7debd7bbc5 Add debug log for each row updsv7 2026-04-13 15:13:42 +09:00
  • 0c64a6f5e9 Add row counter in export updsv7 2026-04-13 15:11:54 +09:00
  • d2e1a4335d Fix NULL value filter in export updsv7 2026-04-13 15:08:10 +09:00
  • 422e8c5934 Rollback to 6a65a45 updsv7 2026-04-13 14:53:23 +09:00
  • 5f76d90851 更新 vba_code_kukan_detail_master.txt simple321vip 2026-04-13 05:51:45 +00:00
  • dddf0e2063 更新 vba_code_kukan_detail_master.txt simple321vip 2026-04-13 05:49:51 +00:00
  • 6c07b145b2 Fix lastDataRow calculation updsv7 2026-04-13 14:45:32 +09:00
  • 6a65a4504e Fix CSV line endings updsv7 2026-04-13 14:40:00 +09:00
  • 692818f837 Revert "Change CSV export to UTF-8 without conversion" updsv7 2026-04-13 14:38:15 +09:00
  • a20da252e0 Change CSV export to UTF-8 without conversion updsv7 2026-04-13 14:37:33 +09:00
  • 5440b5b94f Simplify CSV header export updsv7 2026-04-13 14:33:10 +09:00
  • fddfd9e263 Only validate CSV column count updsv7 2026-04-13 14:22:22 +09:00
  • e09cce2679 更新 vba_code_kukan_detail_master.txt simple321vip 2026-04-13 05:14:41 +00:00
  • 46e4635191 Fix CSV header - use Split at runtime updsv7 2026-04-13 12:47:38 +09:00
  • c68a77f7cc Use array constant for CSV header updsv7 2026-04-13 12:44:33 +09:00
  • ba4dcfc057 Add CSV header validation and use constant updsv7 2026-04-13 12:42:30 +09:00
  • 7d06f12497 更新 vba_code_kukan_detail_master.txt simple321vip 2026-04-13 03:38:20 +00:00
  • 3764a3da3f 更新 vba_code_kukan_detail_master.txt simple321vip 2026-04-13 03:36:50 +00:00
  • d6d54cfd40 Revert to simple worksheet lookup updsv7 2026-04-13 12:29:13 +09:00
  • 30afb491c4 Try to find worksheet by partial match updsv7 2026-04-13 12:28:31 +09:00
  • 30e2b8e5c3 Fix error handling order in FillFromKukanMaster updsv7 2026-04-13 12:25:24 +09:00
  • 8ef6b52785 Add debug to show available worksheets when not found updsv7 2026-04-13 12:23:51 +09:00
  • d3abff7421 更新 vba_code_kukan_detail_master.txt simple321vip 2026-04-13 03:21:50 +00:00
  • 898933ed19 更新 vba_code_kukan_detail_master.txt simple321vip 2026-04-13 03:20:19 +00:00
  • 318314958e 更新 vba_code_kukan_detail_master.txt simple321vip 2026-04-13 03:19:17 +00:00
  • f3465cdcea 更新 vba_code_kukan_detail_master.txt simple321vip 2026-04-13 03:17:58 +00:00
  • 0162cc677e Fix FillFromKukanMaster - ensure D,E columns are filled updsv7 2026-04-13 12:10:43 +09:00
  • f29ea2874b Merge single/multiple cell handling updsv7 2026-04-13 12:06:36 +09:00
  • f17e228412 Simplify C column handling - separate single and multiple cells updsv7 2026-04-13 12:06:08 +09:00
  • 1f94a53a58 Simplify Worksheet_Change for C column updsv7 2026-04-13 12:04:57 +09:00
  • 18212af6ba Remove debug code updsv7 2026-04-13 12:02:01 +09:00
  • 61f6f31fce Add debug and error handling for C column trigger updsv7 2026-04-13 12:00:56 +09:00
  • 65ad779d6d Clear data rows before CSV import updsv7 2026-04-13 11:55:11 +09:00
  • 68a65eecfb 更新 vba_code_kukan_detail_master.txt simple321vip 2026-04-13 02:51:09 +00:00
  • f8f2598d17 Change Japanese MsgBox to English updsv7 2026-04-13 11:40:31 +09:00
  • 105517408f Validate all data rows on button click updsv7 2026-04-13 11:37:02 +09:00
  • 64139ae32c Optimize validateDetailData: simplify logic and parameters updsv7 2026-04-13 11:31:05 +09:00
  • f8f9a0bf79 更新 vba_code_kukan_detail_master.txt simple321vip 2026-04-13 02:28:38 +00:00
  • 08c2112a36 Remove remaining Chinese characters updsv7 2026-04-13 11:26:11 +09:00
  • ce1a81be84 Convert Chinese comments to English updsv7 2026-04-13 11:23:07 +09:00
  • 4de58227ce 添加区間詳細メンテナンス校验宏 validateDetailData root 2026-04-13 11:06:30 +09:00
  • 48a7e893c1 Initial commit simple321vip 2026-04-13 01:59:39 +00:00