Dot in function names Dutch Excel

F

F.H. van Zelm

Hi,

I've always, ever since Excel 4.0, wondered how (and why!) but never dared
to ask ...

Some Dutch Excel worksheet functions have a dot in their name (VERT.ZOEKEN -
VLOOKUP).
The Analysis Toolpak functions are loaded with dots (COUP.DAGEN.DB -
COUPDAYBS).

First question:
How can I, for myself, program a function with a dotted name? Not that I'm
glad to do so but I'd like to program look-a-likes for some of these
functions.

Second:
Why ever did MS allow this type of function name?
(Could the programmer, as a reward, please be send to Guantanamo Bay for
ever?)
 
D

Dana DeLouis

First question:
How can I, for myself, program a function with a dotted name?

Hi. This may not be what you were looking at.
In Excel VBA help, check out "Type Statement"
This is one way I know of where a 'dot' is used.

ie
MyRecord.ID = 12003

= = = = = = = = = = =
HTH
Dana DeLouis
 
F

F.H. van Zelm

Hi Dana,

Thanks for reading and responding.

MyRecord.Id indeed has a dot in the name.

But ...
-----------------------------------------------------------------------------
Function My.Calculation(InputValue As Integer) As Integer
'All manipulation
End Function
-----------------------------------------------------------------------------
doesn't work because of the dot.

But in the Dutch version of Excel VERT.ZOEKEN (with dot) really works.

Mvg, Frans
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top