Dos Prompt Challenges

[saggikarius]

Hi,

We use the csv parser exe file from DOS Command prompt to remove unwanted data.

The following commands are given at the command prompt:
C:\Cd csv correction << This is to go in the folder
C:\Cd csv correction\csv_parrser.exe "abcd.csv" "edited_abcd.csv"

Once hit enter the following appears under this command:
processing file: abcd.csv
removing duplicate word ref.......,53464990 <<<<Some other number here for ref
Output file created: edited_abcd.csv

And then it returns this status
C:\csv correction>_

FYI: The csv_parser.exe has been created with an evaluation version of Perl2Exe: http://www.indigostar.com

It may sound strange, however, what we want is to bypass the command prompt and run this commands via Excel vba dynamically where we can give the user input box to select the file and the folder in which it has to be stored. This is because we want to use this csv parser exe file via citrix where there is no direct way to access the Dos prompt

 

[Andrew Poulsom]

Check out the Shell command in VBA Help. Here's an example:

http://www.mrexcel.com/forum/showthread.php?t=347256

 

[saggikarius]

Check out the Shell command in VBA Help. Here's an example:

http://www.mrexcel.com/forum/showthread.php?t=347256

Thanks Andrew,

However, this is still not working. We gave the path but it says file not found..
Plus, we need to run the command as well which gives the original file name in quote and output filename in quote as per my earlier msg.

If we just give the exe file name with that command "get file" etc.. it will only open or get the exe file. However, this exe file contains the perl script data, so the command should be [C:\abcd.exe "original file name" "output file name"].. What the exe file does is that it runs the script inside the exe file and then extracts the output file in the same folder directly through one command promt entry only. i.e.[covered in brackets above]..

Please assist.. The url which I have provided has the details of how this file was created. However the person who has created is no longer with us.. Hence finding hard time doing this..

Thanks

 

[Andrew Poulsom]

What did you try that didn't work?

 

[saggikarius]

What did you try that didn't work?

We tried to open the file through the command you had provided. And received an error message that the file is not found.

In the DOS Prompt, once we are in the folder where the exe file resides, we give the following command on the prompt.. >"exe fille name" space "original file name" space "revised file name" and once we hit enter, we get the revised file automatically extracted with the data being parsed in that file.

 

[Andrew Poulsom]

Please post the exact code that you used and that didn't work.