PDA

View Full Version : Does anyone use TM pp.exe?


Overcall
09-03-2008, 06:46 PM
Hello all

I currently use DBF Viewer to extract the eight .dbf files files from pp.exe.
Does anyone know the code (VB or C) that will automatically generate txt files
from the .dbf?

Also, Someone wrote that they couldn't save result files (was that from Excel)
There is a lot of literature (Mictrosoft) that handles transfers to and fro Excel
and Access. I save my reults in Access. The tranfer speed is like one second per race.

TIA
vince

Ray2000
09-03-2008, 06:59 PM
Overcall
Not sure if this helps but..

If you want to use a Visual Basic macro from an Excel spreadsheet, you can use the SHELL function
RetVal = Shell(myfilepathname.exe, 4)

myfilepathname is something like C:\Trackmaster\2008\Aug\bml0830r.exe or where ever you saved the file
RetVal is a long integer variable, not used for anything but error trapping

after calling this function the 8 dbf files will be found in Excel's default
folder or the last folder where Excel saved any new file. (This might depend
on Excel version number) In any case, the 8 new files will overwrite any
files with the same name in that folder.

From here Excel will open the dbf files and you can save them in xls format or txt if you want.

Overcall
09-03-2008, 07:33 PM
Thanks for your reply

If you're the one that wrote 'Cards', that what got me thinking of automating that process. Nice work! I use VB so not sure how to eliminate 3rd party software.

Regards
vince

Tom
09-03-2008, 11:42 PM
You can open some of those files with "Open with" and choose Excel.
Then save as text.