Jun 24, 2003 #1 psarros MIS Feb 17, 2002 67 US What is the code used to run a batch file from within excel? I have a buttin in a sheet and I want to run a BAT file when it is pressed. TIA
What is the code used to run a batch file from within excel? I have a buttin in a sheet and I want to run a BAT file when it is pressed. TIA
Jun 24, 2003 #2 S SkipVought Programmer Dec 4, 2001 47,492 US Hi, Use Shell... Code: r = Shell(strDosCommand, vbNormalFocus) where strDosCommand is the path/filename of your .bat file. Hope this helps Skip, Skip@TheOfficeExperts.com http://www.TheOfficeExperts.com Upvote 0 Downvote
Hi, Use Shell... Code: r = Shell(strDosCommand, vbNormalFocus) where strDosCommand is the path/filename of your .bat file. Hope this helps Skip, Skip@TheOfficeExperts.com http://www.TheOfficeExperts.com