Send Excel cell text to command prompt

[miteshpanchal2006]

Hello,

I'm newbie in VBA/Macro and facing one problem.
I want to run few arguments in cmd together.

1. s:\
2. cd\reuters\rpdataadd
3. rpdataadd PATH=D:\temp\loadstuff ACQUIREDDATE=9/4/2012 USEFILENAMEASTITLE=TRUE PRESENTATIONDATE=9/4/2012 ENVIRONMENT=PRODUCTION

I'm using below code

Please Login or Register  to view this content.

Problem I'm facing is, this is not sending whole text into cmd. for 3rd line it is only sending "ENVIRONMENT=PRODUCTION"
Also first two lines are also not delivering into cmd all time. means sometime it works and sometime its not.

I'm hoping to have answer from this thread.

Thanks,

[patel45]

your code works on my test sheet, attach your file

[Cutter]

@ miteshpanchal2006

Please notice that code tags have been added to your post(s). The forum rules require them so please keep that in mind and add them yourself whenever showing code in any of your future posts. To see instructions for applying them, click on the Forum Rules button at the top of the page and read Rule #3.
Thanks.