MS Excel / VBA help thread

You are reading a single comment by @duncs and its replies. Click here to read the full conversation.

•

aggi

I'm sure I've done this many times before but googling is just bringing up excessively complicated scenarios. I want to run a batch file from Excel VBA, no need to pass any arguments to it or anything. What should I be doing? Cheers

•

duncs in reply to @aggi

shell

https://learn.microsoft.com/en-us/office/vba/language/reference/user-interface-help/shell-function

' Specifying 1 as the second argument opens the application in 
' normal size and gives it the focus.
Dim RetVal
RetVal = Shell("C:\WINDOWS\NOTEPAD.EXE", 1)    ' Open Notepad.

•

aggi in reply to @duncs
Cheers, that's what I'm trying but can't get it to run a batch file
```
Sub Editbatch()

Status = Shell("notepad c:\Users\aggi\Desktop\Createfolders.bat ", 1)

End Sub
```
Opens notepad and loads the batch as expected.

But neither

runs the batch. Just get this error. It works fine if I double click it.

MS Excel / VBA help thread

About

LFGSS