writing a date into a cell

Questions and answers about BasicMaker 2018 for Windows
Post Reply
User avatar
Princy557
Posts: 185
Joined: Wed May 18, 2011 10:32 am

writing a date into a cell

Post by Princy557 » Mon Sep 09, 2019 11:19 pm

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 » Thu Jan 16, 2020 3:58 pm

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: 185
Joined: Wed May 18, 2011 10:32 am

Re: writing a date into a cell

Post by Princy557 » Thu Jan 16, 2020 4:24 pm

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”