Call vbscript from python

Question

I'm trying to invoke a vbscript through python as follows

import os
import sys 
import pandas as pd
import numpy as np
rancsv = pd.DataFrame(np.random.randn(150, 5))
rancsv.to_csv('randomcsv.csv', sep=',')
os.system(r"C:\Users\v-2mo\Documents\Python Scripts\test.vbs")

However this simply gives an output of 1 in jupyter notebook and does not run the script.

The script when run directly, runs just fine.

What am I doing wrong?

You need to call it through either wscript.exe (Windows GUI) or cscript.exe (Command line) host applications. — user692942
– user692942, Commented Oct 10, 2017 at 8:49

neophytte · Accepted Answer · 2017-10-10 03:57:06Z

0

os.system(r"C:\\Users\\v-2mo\\Documents\\Python Scripts\\test.vbs")

or

os.system(r"C:/Users/v-2mo/Documents/Python Scripts/test.vbs")

answered Oct 10, 2017 at 3:57

neophytte

7102 gold badges13 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Bilbottom Over a year ago

Doesn't the r prefix mean that you can write \ instead of \\ in your first snippet?

prosody · Accepted Answer · 2022-09-17 00:03:58Z

0

answered well here https://stackoverflow.com/a/19114284/17889328 in short, .vbs opens ok in command prompt because shell associates with program wscriipt or cscript and runs it. run silently your program doesn't get the associationand doesn't know how to open. need specify "wscript filename.vbs" and / or run with shell eg "cmd /c..."

answered Sep 17, 2022 at 0:03

prosody

7041 gold badge7 silver badges16 bronze badges

Collectives™ on Stack Overflow

Call vbscript from python

2 Answers 2

1 Comment

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Linked

Related