View Full Version : Opening Excel Automatically
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
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
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.