Creating Formula

[Colin Haig]

To All

I am using Excel and OLE to generate a maintenance checklist
spreadsheet , the spreadsheet is then downloaded to a palm
device for field technicians to complete - only a date is required
to be entered , what I would like is when the date cell is entered
the current date is entered automatically ( saving the tech on
entering a lot of dates on the small palm screen )

Something like this

oSheet:Cells(nRow,"H"):Formula := "=FillDate()"

Can someone assist me with an Excel formula to do this and how
I associate it with a template sheet.

Thanks for any help

Colin

 

[Dave Peterson]

I don't know about palm devices, but I've seen a few posts that say that some
(all?) don't support macros.

In excel, I can hit ctrl-semicolon (ctrl- and have excel put today's date in
that selection. Maybe it'll work on the palm device, too.

 

[Colin Haig]

Thanks Dave

I cant find those two keys on the palm but I will go to
there web site and do some research.

Cheers

Colin