Creating Formula

C

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
 
D

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top