Dos Prompt Challenges

saggikarius

New Member
Joined
Oct 24, 2005
Messages
23
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
 

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN

saggikarius

New Member
Joined
Oct 24, 2005
Messages
23
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
 

saggikarius

New Member
Joined
Oct 24, 2005
Messages
23
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,129,373
Messages
5,635,884
Members
416,886
Latest member
coreyalaurence37

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top