writing a date into a cell

[Princy557]

Hi,
sorry me again.

One other thing I can't find in the manual is how to write a date into a cell or reading it for that matter.

I've managed the writing and reading of values and text into and out of cells.

[Valeri Vlassov]

An example of writing current date to A1 cell and reading the A1 cell as date:

Dim pm as Object
Set pm = CreateObject("PlanMaker.Application")
pm.Application.Visible = True
pm.Workbooks.Add

pm.ActiveSheet.Range("A1:A1").Item(1, 1).Value = Date
dateFromCell = pm.ActiveSheet.Range("A1:A1").Item(1, 1).Value
MsgBox "dateFromCell is " & dateFromCell

Set pm = Nothing

[Princy557]

Thanks Valeri

I will have a go at this a little later today,
Regards Princy557