Welcome Guest
Log In | Register )
You last visited January 23, 2017, 2:32 am
All times shown are
Eastern Time (GMT-5:00)

Versabet34 to Excel

Topic closed. 1 reply. Last post 11 years ago by libra.

Page 1 of 1
PrintE-mailLink
libra's avatar - chi
Cleveland , Ohio
United States
Member #961
December 27, 2002
44250 Posts
Offline
Posted: July 23, 2006, 12:20 pm - IP Logged

This works with versabet34. First make a folder in your main drive, which is usually C. Name it whatever you want, just so you can find it. I named mine files. Now open Vesabet34 and pick a file you want to transfer to excel. Go to print, click on it,a box will open that says Print Options, you will see 2 options in the lower part of the box. Send to file and send to printer. click on SEND TO FILE. then click on OK. A box opens called PRINT TO FILE. At the bottom it says NAME FILE. Give the file the name of what you are transfering, such as OH3MID. Now go to the top of the box where it says SAVE IN.Click on the the little triangle, you will see a drop down menu ,find LOCAL DISK C ,then find the FILES folder. Go back to the bottom of the box and hit SAVE. Now you can close Versabet34, and open Excel. Go to OPEN , at the top where it says LOOK IN, click the little triangle ,find LOCAL DISK C , then the FILES folder. Click on it, Go to the bottom of the box where it says FILES OF TYPE, click on the little triangle, in the drop down box , cliick on ALL FILES.Your file that you transfered should now show in the box. Click on it. TEXT IMPORT WIZARD should now open up, click on NEXT. Here is where you need to see if you have all of you columns.If not move your mouse pointer to where you want a column line and click , a line will appear. Now hit NEXT again and the hit FINISH. Your file shoud appear in the Excel grid now.Now you can go to Format and set the columns the way you want them as far as DATE , NUMBER,  ALINEMENT, FONT SIZE etc.Don't forget to name and save the file in Excel. Last I can not take credit for this , Bill Mark told me how to do it a while back. Thanks Bill.

Good Luck Libra Dave  Big Smile

    libra's avatar - chi
    Cleveland , Ohio
    United States
    Member #961
    December 27, 2002
    44250 Posts
    Offline
    Posted: July 24, 2006, 12:15 pm - IP Logged

    For the people who have Versabet Lotto Manager , the transfer is almost the same as the above post. Except when you go into print,it brings up PRNTFILE.TXT. Go to EDIT ,click on SELECT ALL , then go to FILE. then click on SAVE AS. At the top of the drop down ,go to SAVE IN ,click on the triangle,click on LOCAL DISK C, then click on the folder you want the file to be in. go to the bottom of the drop down box and name the file, then click on save. The rest is the same as above.

    Good Luck Libra Dave    Big Smile