• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Excel VBA run macro automatically when system date is changed without opening a file

Pinang

New Member
Hi,

Is there any way to run a excel macro without opening a file?

I want to run a excel macro based on system date, when cell A1 is equal to system date then macro should run automatically without opening a file.

Please help.

Thanks in advance.
 

vletm

Excel Ninja
Pinang
Which would check that A1 = date?
Of course, You could run a macro from different file to check if A1 = date in that file ... but ... hmm?
which macro should run then?
You should upload clear sample files and write exact what do You really try to do.
 

Marc L

Excel Ninja
Hi !​
Is there any way to run a excel macro without opening a file?
No as the workbook must be 'opened' (whatever the way) in order to read the cell A1 value ‼​
As here it's the Excel section, next time create your thread in the appropriate VBA section …​
 

Marc L

Excel Ninja
#1 : So your link is within another workbook but as the initial question is 'without opening a file' …​
Like I want my car out of the garage without opening the garage door ! :rolleyes:
So better is to hope for a crystal clear explanation from Pinang …​
 

vletm

Excel Ninja
#1 we have many files and we can run many macros from other files without...
#1.5 ... so You are only allowed user of Your car ;)
#3 that would be nice to see ...
 
Top