Open file if cell date is less than today+30 day?
 

Hi all,
I have had many answers from here from others, but now one new came up.

I have a file which has about 540 rows and 15 colums. In cell H4 =(today)
and i4 is time in days (30). So far we have been operating with conditional
formatting so if next check date is in next month we give orders to our
maintenance.

In col A is mahines ID, B is name etc and col H is next maintenance date.
Purpose would be that if next maintenance should be in 30 days (or 14, we
haven't decided yet) this file would open first thing in morning. But is it
possible to do opening just for certain people? This file is in our server...

Open file if cell date is less than today+30 day?
 

Hi, NeedToKnow. I'm not clear on something. Are you saying...

1) ...that you have a spreadsheet, let's pretend it's named maint.xls, and
if there's something whose maintenance date is coming up you want maint.xls
to open first thing in the morning? There's no way I know of to get an Excel
spreadsheet to open ITSELF up.

2) ...that you want maint.xls to open up some other file if the right
conditions are met? For that I think you need to do a little programming, a
VBA macro in other words. It isn't terribly complicated, but you won't get
it done with worksheet functions; you should move this question to the other
forum.

3) There may be another alternative. It may be possible (I'm not sure) to
have a link displayed opposite any item that meets your criteria, so that the
user can click on them to open the file. Would that suit you just as well?

--- "NeedToKnow" wrote:
I have a file which has about 540 rows and 15 colums. In cell H4 =(today)
and i4 is time in days (30). So far we have been operating with conditional
formatting so if next check date is in next month we give orders to our
maintenance.

In col A is mahines ID, B is name etc and col H is next maintenance date.
Purpose would be that if next maintenance should be in 30 days (or 14, we
haven't decided yet) this file would open first thing in morning. But is it
possible to do opening just for certain people? This file is in our server...

Open file if cell date is less than today+30 day?
 

NeedToKnow wrote:
Hi all,
I have had many answers from here from others, but now one new came up.

I have a file which has about 540 rows and 15 colums. In cell H4 =(today)
and i4 is time in days (30). So far we have been operating with conditional
formatting so if next check date is in next month we give orders to our
maintenance.

In col A is mahines ID, B is name etc and col H is next maintenance date.
Purpose would be that if next maintenance should be in 30 days (or 14, we
haven't decided yet) this file would open first thing in morning. But is it
possible to do opening just for certain people? This file is in our server...


You could use your operating system to open the workbook "first thing". Then
maybe some VBA code to exit if your conditions are not met.