Custom Property of Date Type

C

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)
 
P

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
 

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