Hi,
I'm using date codes on my excel sheet, so 1 being Sunday and 7 being Saturday.
I want excel to open a particular sheet on a particular day. So basically have it watch for 1 or 7 and then load a sheet.
I've tried to modify
=if(E14=1,"Sunday")
and have it look something like
=if(E14=1, application.run("personal.xls!open_sheet"))
Any ideas?
Neil.
I'm using date codes on my excel sheet, so 1 being Sunday and 7 being Saturday.
I want excel to open a particular sheet on a particular day. So basically have it watch for 1 or 7 and then load a sheet.
I've tried to modify
=if(E14=1,"Sunday")
and have it look something like
=if(E14=1, application.run("personal.xls!open_sheet"))
Any ideas?
Neil.