teratail header banner
teratail header banner
質問するログイン新規登録

質問編集履歴

1

2021/09/18 09:49

投稿

takamak
takamak

スコア7

title CHANGED
File without changes
body CHANGED
@@ -8,7 +8,7 @@
8
8
  Sub Aecees集計()
9
9
  Dim objACCESS As Object
10
10
  Set objACCESS = CreateObject("Access.Application")
11
- objACCESS.OpenCurrentDatabase ActiveWorkbook.Path & "\仕入差益物流フィ計算用.accdb"
11
+ objACCESS.OpenCurrentDatabase ActiveWorkbook.Path & "\仕入用.accdb"
12
12
  With objACCESS
13
13
  .Visible = false
14
14
  .Run "Execute_Manager", Format(Cells(2, "c").Value, "yyyymm")