call VBA compiled code within vba
 

Hi There,

How do I call an vba application code within vba code. I
have two application which is saving excel file and the
other one is doing some manipulation of data, but I want
to call the other application within the main vba code.
How could I do that?

Appreciate your help.

TIA
Les

call VBA compiled code within vba
 

Les
You just type the name of the macro to be called within
the main macro.
e.g.

Sub Main()
Dim i, j 'and other declarations

'youre code

'Call the macro
mySave 'the code switches to the next macro
End sub

Sub mySave()
FileSave()
'this code is run and after End sub completes the Main
Macro
End Sub

Peter
-----Original Message-----
Hi There,

How do I call an vba application code within vba code. I
have two application which is saving excel file and the
other one is doing some manipulation of data, but I want
to call the other application within the main vba code.
How could I do that?

Appreciate your help.

TIA
Les

.