Security & Virus | Hardware | Windows XP | Windows Vista | PC Gaming

Run/Open file in VBA

Comment:

I'm writing a macro within excel and in that macro I would like to run a batch file. Could somebody please help me with the syntax? Thanks

Reply:

Hey, simple bit of code here!! in the macro, where you want to run the batch file, simply type: Dim ReturnValue ReturnValue = Shell("C:\FilenameOfBatch.bat",vbNormalFocus) You can replace the vbNormalFocus for whatever you wish, so you can have it so that it is hidden, minimised, maximised etc, after you press the ',' key it will popup a menu and you can pick from that.

0

File Access-VB

C++ variable types

Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.

Summary: I want a "C" source code file to run audio file in Linux. Once compiled the C File, whenvever its function is called in an application the soundfile has to play. The sound files can be replaced its pa...

Summary: Hi I need to know how to execute a file in VBA ...

Summary: Hi everyone, I am programming a parser for a computer science class and I have ran into a problem with my open file. I had a working scanner in which I open the file in the main method and then pass t...