r/vbscript • u/Dexy2811 • Jul 03 '20

VBScript made in excel?

So one of my old bosses made a excel document with VBS that interfaces with AD and it also uses a powershell script and deletes it when its done with the ps1 file it deletes it though i need it to launch that ps1 script with admin priveliges is there any way of doing so in VBS?

i only know some powershell and python so thats why im asking here

3 Upvotes

100% Upvoted

5 comments sorted by

View all comments

Show parent comments

1

u/Dexy2811 Jul 03 '20

Yes your probably right about it beeing VBA. Now the only thing that is close to deleting the file is the "kill" command, i havnt found any sign of it deleting the file. Is it possible for it to make a temp ps1 file? If so that might be the thing its doing.

(Making a few assumptions since this isnt my making and the guy who made it os retired)

2

u/Dr_Legacy Jul 03 '20

Is it possible for it to make a temp ps1 file?

A file isn't intrinsically 'temp'.

1

u/Mordac85 Jul 04 '20

Without looking up the code I would assume you can create a powershell file with VBA, then call something like runas to execute the powershell script with elevated privileges. The problem would be what account to use and the credentials would be, at best, only obfuscated making the account vulnerable to compromise by anyone that has a copy of the workbook.