hiko-blog

VBA業務改善

MENU

2024-03-13から1日間の記事一覧

vbsで Excelvba(.xlsm)起動

VBS

Dim FilePathFilePath = "D:\ThinkpadMark3\自学\filename変更_bat類\.xlsm\繰り返しCopy.xlsm" Dim appSet app = CreateObject("Excel.Application")app.Visible = trueapp.Workbooks.Open FilePathapp.Run "Module1.繰り返し" app.DisplayAlerts = False a…