Search results for query: *

Hi All, In MS Excel there is statement to check current project full path or name: 'ThisWorkbook.FullPath' Is there any way to get around that in Extra? regards, Sagitt

Hi All, Here is my problem, I have a few macros and I cannot put an expiration date on them. I want prevent macros to be unauthorised copied and used. The way I do it on excel is simple: If ThisWorkbook.Fullname <> ' my path' Then Exit Sub So nobody is able to execute a copy of a spreadsheet...

Skip, I use Extra 8.0 and I tried to create array with negative subscripts and all I get is an error of subscript out of range any time I use negative values. How can I manage to get it done on Extra Basic? Here is my code: Sub Main dim i as long dim tmp() as variant...

Hi All, I need to check if .ebm file that contains a macro is stored in a specific folder (basically I do not want the users to copy a macro file to their personal folders). In Excel this is very simple. Say I have MyFile.xls saved in C:\MyFolder folder. So the code is like that: if...

After a long battle I got my task done this way: I needed capacity of approx 80 000 entries, so anyway one dimensional array would not do the job for me. So I started some experiments with 2D arrays. For unknown to me reasons extra basic is limited to 65000 values for 2D array; the best...

Hi All, Does anybody know what is the maximum size (length) for one dimensional array? I have declared an array as Variant and array index as Long, however when I try to populate the array with a data it gives me an Overflow error (number 6) when it reach 32768 - which my understanding is a...

Hi Buddha, I got the same issue. I had all variables declared explicitly wits keyword "Global", and it seems to me that Extra did not like it. After i changed "global" to "Dim" everything was running smoothly. So point I have learnt out of that was: 1. avoid global declarations for...

Hi All, Just a quick question about how to protect code from being changed. When I go to Files - Properties - Security in macro editor I can set up a password that will prevent my code from changes. That is fine. However, if you open the same .ebm file with Notepad (or any text editor) you will...