Trigger Required in Advanced Excel VBA Macros

[onlyprasad4u]

Is there any possibility to open PC on a particular time, and open a particular Excel session and run, compile it and send to particular Client (Internal Outlook or external email id) on a particular time as mentioned daily or set it on a particular time. For this, System needs to turned On Automatically and Run the given Program through VBA.

If it is possible please explain me with the details. This would help me a lot in my current role.


Thank you in Advance,
Prasad

 

[Arjun.Singh]

You need a robot in your current role to switch on power supply and power up your pc

The rest can be looked into but the first part of your problem cannot be helped by any MS application.

 

[onlyprasad4u]

Can you give me an example for the rest of the problem?

 

[Arjun.Singh]

You need to have all the programming done first. Then, once you figure out how to get your pc switch on, have the link/shortcut of file or program you've created in the startup folder in start menu.

1. Use workbook.open to do the processing required.
2. Make sure your file can read the system time etc. accordingly.

If you have sample workbooks ready please share those, if not create some and share with us.