View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Peter Atherton Peter Atherton is offline
external usenet poster
 
Posts: 31
Default 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

.