PC Review


Reply
Thread Tools Rate Thread

Date stamp spreadsheet in excel to remind me of completion date

 
 
=?Utf-8?B?QmlnIGZlbGxh?=
Guest
Posts: n/a
 
      18th Oct 2005
is it possible to have a date stamp imbeded in a spreadsheet so that progress
on any work can be prompted.
Can the spreadsheet be linked to an electronic calendar so it send you an
auto reminder to open that spreadsheet at a certain date & time.
 
Reply With Quote
 
 
 
 
=?Utf-8?B?VmFjYXRpb24ncyBPdmVy?=
Guest
Posts: n/a
 
      18th Oct 2005
generally speaking code needs to be open to run.

a file cannot open itself

That said, if you want to put a macro in Personal.XLA that checks the date
and time and then selects files to open that can be accomplished.

This will not run unless Excel is open.

two ways to run this would be the personal.xla Open event to check each time
you launch Excel

or the "ontime" function that will check every ___ min or hours to see if
something needs to be done.



"Big fella" wrote:

> is it possible to have a date stamp imbeded in a spreadsheet so that progress
> on any work can be prompted.
> Can the spreadsheet be linked to an electronic calendar so it send you an
> auto reminder to open that spreadsheet at a certain date & time.

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
auto date completion or insert date in word 2007 =?Utf-8?B?ZHQ0NmR0NDZkdDQ2?= Microsoft Word Document Management 1 12th Aug 2007 05:58 AM
How can you save a spreadsheet with a date stamp. =?Utf-8?B?a2Vubnk=?= Microsoft Excel Worksheet Functions 1 15th May 2006 05:19 PM
how do I fix the date stamp in excel? joe54345@gmail.com Microsoft Excel Worksheet Functions 5 5th Mar 2006 03:08 PM
date stamp Can I add a date stamp in a Text or Memo Field =?Utf-8?B?TWljaGFlbCBM?= Microsoft Access Database Table Design 10 11th Apr 2005 02:29 AM
date stamp & appointment tru excel =?Utf-8?B?UCBEaXJrcw==?= Microsoft Excel Programming 0 19th Dec 2004 12:29 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:43 AM.