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...

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...

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 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...