How to execute the ".bat" files using excel VBA !?

Dear all,

I was created a macro VBA to run ".BAT" files so I can copy some documents with different formats into excel.
When I try on my ".BAT" files created by execute it manually was running fine without any problems.
However, I was failed to get my results when I tried to execute the ".BAT" files with excel macro VBA.

Can anyone helps me on this? Below is my VBA codes created.

Thanks in advance.

__________________________________________________________________________

Please Login or Register  to view this content.

_______________________________________________________________________________________________

Hi,

you can simply do this :

Please Login or Register  to view this content.

Hi xlbiznes,

I'm just tried your advice just now and test run the VBA still resulted failed to get my results.
Any ideas?
Untitled.jpg

Hi,

Please enclose the code of your first post in the code block.

firstly ,Does your batch file get executed from the vba ?

What i have understood now is that your batch file executes but no result is derived from it.

On the other hand if you run the batch file from the command prompt you are able to get the desired result.

Hi xlbiznes,

Done enclose the codes of my first post in code block as your advice. Thanks.

For your info, my batch files did execute with VBA but no results is derived from it as your finding.
I tried to execute the batch files manually by double click on the batch files are able to get the desired results without any problems.

Any advice on this?
Is there any problems with my codes?

Kindly helps me on this. Thanks in advance and appreciate your helps.