Macro

S

Sophie

Is it possible create a macro that opens an excel file at a certain time automatically
 
G

Gord Dibben

Sophie

Yes, it is possible using the OnTime method.

See Chip Pearson's site.

http://www.cpearson.com/excel/ontime.htm

You can open the file from another workbook that is running and has the OnTime
code in it.

An alternative if Excel is not running is to start Excel with your particular
file. You could use Windows Task Scheduler and a startup switch in the
shortcut to Excel to do that.

Gord Dibben Excel MVP
 

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

Similar Threads

Need Help with Macro Security 1
Macro warning in word 1
VBA word change keys 0
MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1
Default local file location - folder redirection slowness 0
Macro to select and delete levels of a document 2
Cell data entering slow! 0
Macro to copy table of contents to a new doc 0

Top