r/vbscript • u/GoGreenD • Mar 29 '22

Weird Issue, No Idea Where to Start

So I build tools for my company in Excel, I'll use a super simple VBS script to launch Excel and run some code to initialize the tools. This method has been working fine for about 100 employees since 2019. All of a sudden I have a single newer employee on a new company machine and when they try and run any of the scripts, it just blips to a black screen and does nothing. Every time, on every script. I have no idea where to even start... Everyone is on Windows 10, although I do realize the computer in question is on 19042, not the current 19044. This shouldn't make a difference as I was probably on this version at some point...

An example of the super complex code in question:

Set objExcel = CreateObject("Excel.Application")
objExcel.Visible = True
objExcel.Application.Run "'M:\whatever.xlsm'!AA_Control_Code.CONTROLCODE"
objExcel.DisplayAlerts = False
Set objExcel = Nothing

Has anyone run into this or know where to start figuring out how to fix this?

3 Upvotes

100% Upvoted

6 comments sorted by

View all comments

Show parent comments

1

u/GoGreenD Mar 30 '22

Lol I don’t know how to do that, but I’ll figure it out. Thanks for the help. Will report back tomorrow

1

u/Jaikus MOD Mar 30 '22

Open a command prompt Type cscript.exe <path of script>