I have accountin software that produces a .dat file for BACS transmission. We have a new bank (& new BACS type) that can't accept our current file format.
The only issuse with the file is two header lines (the first two lines of the file) need to be removed, it's then transmitted to the bank using standard polling software - the process is done by the user (based in a different country).
I need to be able to create an executable file (dos batch/compiled exe etc) that will allow
-browse to file (file is usually FTP'd from accounting software server to c:\temp, but that could be variable)
-the .dat filename can also be variable
-Remove the first 2 lines from the file (lines aren't numbered, or unique in any way)
-Save the file with original filename & preserve all other formatting
-The user should not "see" the file content during the process
-& finally open the polling software for bank transmission (again, it's location could be variable, but that should just be a small code change before it's compiled to install on users desktop)
I've searched some the the current solutions for this, but most involve the user either needing (for instance) some kind of dev software & "seeing" whats happening - I need the process to "look" completely automatic.
Can anyone help me get started?
When finished and everything is ok, the delete file A (or rename it to A.ori) and then rename file B to file A.
Then launch your polling software.