How to launch batch file from vba excel

With ADODB You are able to use table manipulation commands such as add record, delete record, add column, delete column, etc. Excel on the mac supports read-only operations. You can perform select, order by, group by, paramter queries, etc but you can not do table manipulations. A work-around might be to have an Excel file in the shared directory that VBA could manipulate from within Mac Excel, but I've never tried such a feat.

If you could figure out the file paths you might be able to do this. In reply to RajivDixit's post on June 19, The Mac can not open and process the batch file. As Bob says, you can not execute a batch file on a Mac. This site in other languages x. You can follow the question or vote as helpful, but you cannot reply to this thread.

Threats include any threat of suicide, violence, or harm to another. Any content of an adult theme or inappropriate to a community web site. Any image, link, or discussion of nudity.

Any behavior that is insulting, rude, vulgar, desecrating, or showing disrespect. Any behavior that appears to violate End user license agreements, including providing product keys or links to pirated software. Unsolicited bulk mail or bulk advertising.

Any link to or advocacy of virus, spyware, malware, or phishing sites. Dec 7, franklins. Solved MAcro or BAtch file to change cell format. Replies 7 Views Oct 6, GWteB. Solved vba wait until batch file is complete. Jake Jun 21, Excel Questions. Replies 4 Views Jun 28, Jake SeaTigr Nov 8, Excel Questions. Nov 8, SeaTigr. Mac Nov 12, Excel Questions. Replies 1 Views Nov 12, jasonb Understanding data is crucial, and the easiest place to start is with Microsoft Excel.

Forum statistics Threads 1,, Messages 5,, Members , Latest member eriddell Log in. Install the app. If you forgot your password, you can reset your password. JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding. You are using an out of date browser. It may not display this or other websites correctly. You should upgrade or use an alternative browser. Run batch files using Excel VBA.

Thread starter Martin Start date Feb 10, Tags excel executable file files run. Martin New Member. Joined Mar 29, Messages 9. I need to run multiple files using software from outside Excel. However, to be efficient over the weekend, I would like to use Excel to open each file, run the file and after finishing, close it off and run the next file.