|
JCapper Message Board JCapper 101
|
| Home |
Register
Log In |
| By | ForBill export problem | |
| JimmyM 2/28/2025 9:09:30 AM | Jeff, I'm trying to export the forbill file to an excel spreadsheet. Every time I do, the data exported stops at cell JD. I can see the info on the header all the way to cell NM but not the associated data. It's missing. Any suggestions on how to export the data all the way to cell NM? Thanks Jimmy
| |
| jeff 2/28/2025 2:15:57 PM | Hey Jimmy, What are you running to perform the export? -jp .
| |
| JimmyM 2/28/2025 4:19:20 PM | I'm running Windows 11. And I'm using the excel that comes with my Microsoft 365 personal.
| |
| jeff 2/28/2025 10:26:38 PM | Are you running a program or VBA Macro to load the ForBill.txt file into Excel? The ForBill.txt file isn't a flat file. Bringing it into Excel requires special handling. Here's a link to Field Mapping for the ForBill.txt file: http://www.jcapper.com/HelpDocs/ForBillDoc.htm The Field Mapping doc at the above link also contains VB6 or VBA source code that reads the file into memory. Hint: The data in the bottom (Horse Data) section of the ForBill.txt file is what most players are interested in. My intent for including the code routine in the doc is to enable the player with some VB6 or VBA experience to use it in a VBA Macro. The part you'd need to add would be doing something useful with the data from the file after it's been read into memory: Like writing it to a flat .csv file, populating selected cells in an Excel spreadsheet, or making calculations and generating your own custom reports. -jp .
| |
| JimmyM 2/28/2025 11:47:21 PM | LOL. I'm old school and I have no idea what you just said... After running a calculate races, I just want to use the info on the forbill file to see what winners have in common like top 2 bris rank or cpace rank after I export it to an excel spreadsheet. jm
|
| Reply |
|
Copyright © 2018 JCapper Software back to the JCapper Message Board www.JCapper.com |