Gruss Forum • View topic

by **Dedes** » Wed May 03, 2006 2:34 pm

a1ehouse wrote: If you want to change to Euros feel free, just highlight the column in Excel right click and format the cells to your currency as normal. It's not programmed on the form (...yet ).

It didn't work! I went to cell B3 and changed to Euros but on the Ladder I keep seing £

Can you help?

by **a1ehouse** » Wed May 03, 2006 5:49 pm

Oh! Total Matched you mean?! I will have to add another preference on the next release. :lol:

by **Dedes** » Wed May 03, 2006 7:12 pm

A1ehouse,

Thanks!

Please, read my post on page 2. Its the last one on that page.

by **jon** » Thu May 04, 2006 1:59 pm

HELP ...

I downloaded the ladder file from the start of this thread to my pc ... but I have open office in place of excell .

I find when clicking on the button to open the ladder nothing happens.

Any help please.

Thanks,
jon.

by **GeorgeUK** » Thu May 04, 2006 2:08 pm

It will only work with excel

In Open Office, you can write sub programs (macros) to automate tasks. This is what a1ehouse has done with BLadder.
Excel uses VBA programming language
Open Office uses Basic

You can't run a VBA macro in oOo

Not sure if there is a free viewer that allows macros to run for excel. At work right now so can't really search for anything.

by **jon** » Thu May 04, 2006 3:33 pm

Hi Georgeuk

I do have XLviewer 2003 . If I open that ... im told read only.

Any idea how to change from read only.

Thanks,
jon.

by **GeorgeUK** » Thu May 04, 2006 4:10 pm

Never used XLViewer so not sure what you should or shouldn't be able to do with it.

Check that the workbook is not set to readonly.
rightclick the workbook (in the folder) and uncheck read only.

Is it not letting you open the workbook at all?

by **jon** » Thu May 04, 2006 4:15 pm

Where is the workbook

jon

by **jon** » Thu May 04, 2006 4:22 pm

right ... found the workbook , it shows no tick in the read only box but at the top of the xlviewer

page it shows read only ... im confused.

jon.

by **GeorgeUK** » Thu May 04, 2006 4:43 pm

If the workbook is read only - does that not just mean you can't save any changes to it?

You may want to check to see if the viewer can run macros or not.
As i said, at work right now so can't really assist. Will try later tonight if no-one else pitches in.

EDIT: You may want to check the security levels to see if macros are enabled or not.
In excel this is under tools - options - security tab

by **jon** » Thu May 04, 2006 8:04 pm

No joy

by **GeorgeUK** » Thu May 04, 2006 10:39 pm

Done a bit of digging

Sorry to say that XLViewer will only view an existing workbook - you can't do anything at all with it except look at what is already there. It really is read only. You can't alter any of the cells at all. It will also not run macros, so i'm afraid your stumped.

by **one cool dog** » Fri May 05, 2006 8:50 pm

Hi it has been mentioned here before, but not really answered, but every time I double click on the Open Bladder option on the Excel sheet - small grey box - i get asked for a VB Project password.

Obviously this is wrong but I have no idea if

a) this means I do not have the right compatability for the software?

b) is I need to install something to help?

I know 99% of people probably are laughing at me, but I do handle some software myself - don't develop it, just do customer care on it - and I know there is nothing worse than having irritating little problems stall your progress. I have attached some screen shots to explain the problem.

Help would be greatly appreciated as it looks really good.

by **GeorgeUK** » Fri May 05, 2006 9:04 pm

looks like you are in edit mode - do you have macros enabled in your security settings?

by **a1ehouse** » Fri May 05, 2006 9:24 pm

GeorgeUK is right, you are opening in design mode. Click the Protractor Icon which is above the words cmdOpenBLa... in your screenshot to turn off VBA Design Mode.

bLadDeR_1.4.xls release (link inside)

Who is online

Sports betting software from Gruss Software