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

N

NeedToKnow

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

Bob Bridges

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?
 
G

Glenn

NeedToKnow said:
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.
 

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

Top