ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Run CMD within Excel Macro (https://www.excelbanter.com/excel-discussion-misc-queries/102971-run-cmd-within-excel-macro.html)

ledzepe

Run CMD within Excel Macro
 

Hello everyone,

I made a macro to extract a report from a big.csv file and save the
result to small.csv file. I need to run a bathc file command to append
the small.csv file to a third .csv (let's call it result.csv). Can I do
that within the Excel macro?

Thanks in advance.


--
ledzepe
------------------------------------------------------------------------
ledzepe's Profile: http://www.excelforum.com/member.php...o&userid=25207
View this thread: http://www.excelforum.com/showthread...hreadid=567991


Dave Peterson

Run CMD within Excel Macro
 
Ron de Bruin shows how to create a .bat file via code and run that .bat file:

http://www.rondebruin.nl/csv.htm



ledzepe wrote:

Hello everyone,

I made a macro to extract a report from a big.csv file and save the
result to small.csv file. I need to run a bathc file command to append
the small.csv file to a third .csv (let's call it result.csv). Can I do
that within the Excel macro?

Thanks in advance.

--
ledzepe
------------------------------------------------------------------------
ledzepe's Profile: http://www.excelforum.com/member.php...o&userid=25207
View this thread: http://www.excelforum.com/showthread...hreadid=567991


--

Dave Peterson


All times are GMT +1. The time now is 02:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com