Excel Macro

Hi all,

Im currently trying to write a macro that will be used in excel. What the macro needs to do is when run, open an excel template that is stored on the hard drive.

Im completly stuck on the ode for this one, I only recently started my software design course at college and have not advanced much.

Any help muchly appreciated :)

Mark

Welcome to the Forums.

Easiest way to see how its done is to record a macro in Excel doing the task. Then stop and view the generated module code. Then ou can tweak it for use in either Excel or VB 6 etc.

Ahhh, brilliant thanks mate.

sorry never introduced my self bit rushed here at work

Cheers again m8 :)