Custom Property of Date Type

[CarlOlen]

How do I update using VBA a custom property of the DATE data type?

The formula content of the cell (cellObj.formual) content prints out as:

DATETIME(39643.5)

But, when I want to set a date for the cutom property I have it in a format
such as
7/14/2008 2:33:07 PM

How do I set the formula correctly? Please let me know.

(P.S. does anybody know how to get the number value of a date? e.g., 39643.5)

 

[Paul Herber]

How do I update using VBA a custom property of the DATE data type?

The formula content of the cell (cellObj.formual) content prints out as:

DATETIME(39643.5)

But, when I want to set a date for the cutom property I have it in a format
such as
7/14/2008 2:33:07 PM

How do I set the formula correctly? Please let me know.

(P.S. does anybody know how to get the number value of a date? e.g., 39643.5)

If you have a look in the VBA help there is a whole section on this.
A web search finds the first hit:
http://msdn.microsoft.com/en-us/library/aa212663(office.11).aspx

 

[Chris Roth [Visio MVP]]

Hi Carl,

I've got a post on the Visio Guy forum that discusses this:

http://visguy.com/vgforum/index.php?topic=215.0


--
Hope this helps,

Chris Roth
Visio MVP


Visio Guy: Smart Graphics for Visual People

Articles: http://www.visguy.com
Shapes: http://www.visguy.com/shapes
Dev: http://www.visguy.com/category/development/
Forum: http://www.viguy.com/vgforum