writing a date into a cell

Post Reply
User avatar
Princy557
Posts: 192
Joined: Wed May 18, 2011 10:32 am

writing a date into a cell

Post by Princy557 »

Hi,
sorry me again. :o

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.
Regards

Princy557
Valeri Vlassov
SoftMaker Team
SoftMaker Team
Posts: 3
Joined: Mon Dec 30, 2019 4:01 pm

Re: writing a date into a cell

Post by 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
User avatar
Princy557
Posts: 192
Joined: Wed May 18, 2011 10:32 am

Re: writing a date into a cell

Post by Princy557 »

Thanks Valeri

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

Princy557
Post Reply

Return to “BasicMaker 2018 for Windows”