code to force xls file to open after several hours passed

  • Thread starter Thread starter helmekki
  • Start date Start date
H

helmekki

Hi All

i am tring to write a code to force xls file open by it self whe
several hours (any number of hours, say 3 hours) has passed..

either pased on a condition Like A1=Now() so when 3 hours paased then
or
based on the computer time so after 3 hours passed then

my try was as follwing (placed in workbook_open) or somewhere else

If A1
getopenfile( file path)
end if

any help is appreciated in advance
 
You must log in or register to reply here.

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

Sub to open n close .xls files in folders 5
Using a string variable to change a file name 2
Passing sheet names to an array 3
Code execution is correct but generates Error :The file you aretrying to open is in a different form 3
Sub to check & force open Parent.xls 6
How to code it in macro? 2
Open file from path in cell and open from current file path 0
Use external file variable in formula 2

Back
Top