PDA

View Full Version : Opening Excel Automatically



Gil
02-18-2014, 05:37 AM
Hello everyone

Is it possible to open Excel automatically when a condition is met for example when a date is approaching. This is to save opening workbooks unnecessarily.

I have looked through several sites already but can only find code that will open through an already running program.

Any help would be appreciated even if the answer is no it is not possible.

Thank you for now

Bob Phillips
02-18-2014, 05:46 AM
You should be able to use Windows Scheduler together with a VB Script. Not sure if this helps, but check out http://stackoverflow.com/questions/18504067/how-to-automate-the-forced-closure-of-excel-followed-by-a-restart/18654283#18654283

Gil
02-19-2014, 03:44 PM
Hello xld

Thank you for the reply, I tried the link you supplied but didn't get anywhere with it. Looked 'all over' the web last night and today but still got nowhere.

Also I am not sure if I am in the right forum, this one seems to be general and not specific to Excel. Can it be transferred to see if a wider audience can help.

Many thanks
Gil

Jomathr
02-19-2014, 05:19 PM
From what I understand you would need to use Windows Scheduler (Control Panel / Scheduled Tasks / Add Scheduled Task) and in excel in your personal.xlsb you can add your code to open the workbook. I never tried it for this use.

Here is some more info: http://www.office.microsoft.com/en-ca/excel-help/running-a-macro-when-excel-starts-HA001034628.aspx it's for excel 2000 and 2002 but the theory remains the same for later versions.

Hope it helped