Re: Looking for * in strings.

hi Douglas,

Douglas J Steele works:
This doesn't make any sense, Stefan.
You cannot use Access unless you have a database loaded: it's not intended
for that purpose.
This is correct, but not my problem here. May be i haven't made it clear:

InStr seems to be an overloaded function. These functions can be called at the same time, but they have different boundary conditions, which are _not_ documented.

They have serious side effects.

It would be the equivalent of trying to use Word without a
document open, or Excel without a workbook open.
Never used an Excel function in Access?

Public Function ExcelMin(ParamArray Args()) As Double

Dim objExcel As New Excel.Application

ExcelMin = objExcel.WorksheetFunction.Min(Args())

End Function

Exactly what are you trying to do that you feel it's necessary to have VBA
functionality available to you without having an MDB open?
A test revealed a serious side effect of an overloaded function, how can this be ignored?


mfG
--> stefan <--
.

Relevant Pages

  • Re: Looking for * in strings.
    ... The function not working properly in the Immediate Window doesn't ... Doug Steele, Microsoft Access MVP ... InStr seems to be an overloaded function. ... Never used an Excel function in Access? ...
    (microsoft.public.access.formscoding)
  • Re: Looking for * in strings.
    ... You can use instr unless you open a mdb file. ... This has NOTHING to do with searching for a asterisk. ... InStr seems to be an overloaded function. ...
    (microsoft.public.access.formscoding)