All Questions
Tagged with wscript.shell excel
9
questions
0
votes
1
answer
307
views
VBA Wscript.Shell Run — how to run a script with high priority?
I'm want to run my python script from Excel VBA and this code works:
Dim newShell As Object
Dim PythonExePath As String, PythonScriptPath As String
Set newShell = VBA.CreateObject("Wscript.Shell&...
0
votes
0
answers
104
views
vba WScript.Shell to run exe with JSON string as argument
I'm attempting to run an exe via command line that requires a JSON string as an argument. Inside that JSON string are dynamic start/end date variables, and a file name variable.
I'm able to run the ...
- 65
0
votes
1
answer
816
views
Using WScript with MS Edge to download multiple files leaves open Edge tabs
I am using a Wscript shell to automate the download of multiple (Excel files). The shell command creates a new tab (and popup window) in MS Edge for every download. What I would like is to create a ...
- 4,181
2
votes
1
answer
1k
views
WScript.Shell crashes Excel
I am using WshShell to run a batch file from VBA within Excel.
The batch file is VERY simple, one line that runs a number crunching
program. I can run the batch file directly without problems.
I am ...
- 83
0
votes
0
answers
137
views
VBA code that executes two .bat files one after another
I'm trying to write a code that would create and execute two batch scripts, one after another. The 1st makes a given number of copies of my pdf file (makecopies.bat) and the 2nd one changes the names ...
- 1
0
votes
1
answer
784
views
Search txt and csv files for string using Excel VBA without opening files
I have a text file that is automatically generated from a machine. The machine writes the txt file in "chunks" (sorry I don't know the exact terminology). I need to pull data from this txt file, but I ...
- 179
0
votes
1
answer
134
views
Problem running Rscript in Excel 2013 through shell
I have been successfully running my r script in Excel 2010 & Windows 7 using vba for a long time. Then I had to use another computer which has Excel 2013 & Windows 8 installed. It gets me the ...
- 81
0
votes
1
answer
314
views
How to file filter using wscript.shell when populating with Application.WorksheetFunction.Transpose(files)
Cannot determine the correct parameter to file filter with recursive wscript.shell.
Have tried to filter in Application.FileDialog, failed.
Have tried to include .txt extension following dir, failed, ...
- 131
0
votes
0
answers
865
views
How to capture shell WScript Shell output from Excel VBA without using cmd?
I have used the various posts similar to this and come up with the following, but not sure why this doesn't work for me. I have a UserForm wherein I am trying to run a script and capture the output, ...
- 655