Executing DOS commands using VBA

[thinksriniii]

Hi Guys,

Could you please help me on how to execute these DOS commands using a Macro.

ü Go to command prompt and execute ‘CD D:\BATCH’<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
ü Execute ‘SETENVD UK BB’ (UK – country code ; BB – Report type)<o></o>
ü Execute ‘DEDT’<o></o>
ü Execute ‘DEO’<o></o>
ü Execute ‘CODE’<o></o>
ü Execute ‘STAT’<o></o>
ü Execute ‘KEY’<o></o>
ü Execute ‘USERHELP’<o></o>
ü Execute ‘XVAL’<o></o>
ü Execute ‘COMPALL UK BB’<o></o>
ü Execute ‘VIEWD UK BB’

And the Macro should automatically run everyday at 9AM.

Cheers,
Costa Dave

<o></o>

 

[mubashiraziz]

Hi Guys,

Could you please help me on how to execute these DOS commands using a Macro.

And the Macro should automatically run everyday at 9AM.

Cheers,
Costa Dave

<o></o>

Basically you needs batch programming because VBA only runs when we run Excel ......

Or you can use Schedule Task in Control Panel ..... which we can do various things ....

 

[thinksriniii]

Then, Probably i would remove the last part of my question. Its enough now to incorporate it in VBA.

Cheers,
Dave

 

[RoryA]

Can't you simply put those commands into a batch file and call that from VBA?

 

[thinksriniii]

Hi Rory,

Many thanks for your reply. But, am a newbie to VBA. Could you please explain how to do it.

Cheers,
Dave Costa