Ananthak275
Board Regular
- Joined
- Aug 22, 2020
- Messages
- 128
- Office Version
- 2013
- Platform
- Windows
- MacOS
Hello everyone,
I'm trying to run this VBS script. It should go into the file "Hello.xlsm", Sheet1(in the example, it was module1, i assumed this was referring to the sheet name so i changed it to Sheet1), and "sched" is the name of the macro. it runs but dont show up anything.
The macro within "Hello.xlsm"
I'm trying to run this VBS script. It should go into the file "Hello.xlsm", Sheet1(in the example, it was module1, i assumed this was referring to the sheet name so i changed it to Sheet1), and "sched" is the name of the macro. it runs but dont show up anything.
set objexcel = CreateObject("Excel.Application")
objExcel.Application.Run "'C:\Hello.xlsm'!Sheet1.sched"
objExcel.DisplayAlerts = False
objExcel.Application.Quit
The macro within "Hello.xlsm"
Very simple macro. Not sure what the error isSub sched()
MsgBox "hello hello hi hi hi !!!!!"
End Sub