Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Pass a blank date
Message
De
22/05/2007 09:43:36
Jerry Tovar
Dana Corporation Dana It
Maumee, Ohio, États-Unis
 
 
À
Tous
Information générale
Forum:
Visual Basic
Catégorie:
VBA
Titre:
Pass a blank date
Divers
Thread ID:
01227613
Message ID:
01227613
Vues:
56
Using VBA, can I pass a blank date to a COM object?

I have a VFP COM DLL that will accept parameters to write to a record. One parameter is a date. I want the date parameter to accept blank dates. How do I pass a blank date or null from a VBA script to this COM object?
Dim Mydate As Date
Dim o As New MyCom.MyCom

'This works but the date accepted in VFP is 12-30-1899.
o.AddContact("Name", Mydate)

'Works.
o.AddContact("Name", #5/1/2007#)

'Does NOT work. Want to pass blank date.
o.AddContact("Name", ##)
Thanks,

Jerry
Répondre
Fil
Voir

Click here to load this message in the networking platform