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?

 

[VoG]

You can use the OnTime method http://www.ozgrid.com/Excel/run-macro-on-time.htm


For learning VBA see Hiker's List http://www.mrexcel.com/forum/showpost.php?p=3108312&postcount=5

 

[mahmed1]

Hi,

I have no clue how this is working. Would this work automatically even though the file i am running is not an excel file but i save that file as an excel file?

On the impromptu file, when i open it, i have to press ok for the file to be run.
Once it has completed i save as an excel.xls file.

What can i do to use the ontime method to do this.
I will check out hikers list.

Thank you hun

 

[VoG]

I think that I misunderstood - OnTime will only work with VBA code in Excel files.

Take a look at Windows Task Scheduler for running other processes automatically.

 

[mahmed1]

I think that I misunderstood - OnTime will only work with VBA code in Excel files.

Take a look at Windows Task Scheduler for running other processes automatically.

Hi vog,

Where can i find that?

 

[VoG]

Which version of Windows?

 

[mahmed1]

Which version of Windows?

Hi how would i find that out on my work computer?

Would i have to download this on my work computer as i dont think i will be allowed to do this.
If it is already there, how can i use this? This will save huge amount of time

 

[VoG]

Click Start, click Run, type

winver

then click OK.

 

[mahmed1]

Click Start, click Run, type

winver

then click OK.

Hi hun, as far as i can see it says windows 6.0

 

[VoG]

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.