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

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 wrote:
>
> 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
(E-Mail Removed)

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