-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Disable XLSTART for scheduled Auto-Run Macros
- Thread starter kozelibe
- Start date
Jaafar Tribak
Well-known Member
- Joined
- Dec 5, 2002
- Messages
- 9,806
- Office Version
- 2016
- Platform
- Windows
If you can run VBSCRIPT on your machine then you can try the following :
1 Open Notepad and put the codebelow in it :
Where C:\Test.xls is the FullName of the workbook you are trying to run with Task scheduler. Change this FullName as required.
2- Save the notepad file to disk and give a VBS extension
3- Schedule the VBS file instead of the workbook file.
1 Open Notepad and put the codebelow in it :
Code:
Createobject ("Excel.Application").Workbooks.Open("C:\Test.xls").Application.Visible=TrueWhere C:\Test.xls is the FullName of the workbook you are trying to run with Task scheduler. Change this FullName as required.
2- Save the notepad file to disk and give a VBS extension
3- Schedule the VBS file instead of the workbook file.
Upvote
0
Similar threads
- Question
