Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Pass a blank date
Message
From
22/05/2007 09:43:36
Jerry Tovar
Dana Corporation Dana It
Maumee, Ohio, United States
 
 
To
All
General information
Forum:
Visual Basic
Category:
VBA
Title:
Pass a blank date
Miscellaneous
Thread ID:
01227613
Message ID:
01227613
Views:
57
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
Reply
Map
View

Click here to load this message in the networking platform