Automating macro

[mahmed1]

Hello,

This is my 1st post and I am a complete newbie to excel and vba so apologies if i am not making any sense.

My manager has tasked me to run an impromptu imr file on a daily basis which i then save the file as an excel file once it has run.
Each day, many other colleagues also run several of other impromtu files which then slows it down and takes over 2-3 hours to run.

I wanted to ask for your advice. Is there a way to make my life easy, somehow automatically run this at 3am in the morning so that no one else will be running anything and when i come to work, the file would have been done and saved as an excel file.

Apologies if i am asking a stupid question.

Has anyone got any links where i can learn vba?

 

[mahmed1]

I assume that is Windows Vista so try this http://windows.microsoft.com/en-US/windows-vista/Schedule-a-task

It should be similar in other versions of Windows.

Hi vog,

Thank you. Would this method guess i will be able to run that file however how can i save that file as an excel file after it has run?
I have to run 4 files and do the same process however i cant run 4 all at once.
I have to run it once each one has completed. So once the 1st one runs and saves an excel file, then do the 2nd and so forth

Thank you hun

 

[VoG]

You would need to create a batch file to run your 4 processes in sequence then schedule that to run automatically. Google windows batch file.


This thread is no longer a strictly Excel-related question so I am going to move it (leaving a link)).

 

[mahmed1]

You would need to create a batch file to run your 4 processes in sequence then schedule that to run automatically. Google windows batch file.


This thread is no longer a strictly Excel-related question so I am going to move it (leaving a link)).

Sorry vog,

I was not sure if this was an excel query

Thank you