LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.programming
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

.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I call VBA subs from different spreadsheet from code behind form? clhamilton Excel Discussion (Misc queries) 1 June 12th 09 05:47 PM
Compiled data from many files Unda Excel Worksheet Functions 1 April 21st 08 08:56 PM
Excel code to call a macro when a certain value in a cell isselected. [email protected] Excel Worksheet Functions 4 February 15th 08 08:18 PM
Can you call a Web Service from Excel 2007 without writing code? BigBadBubba Excel Discussion (Misc queries) 0 March 14th 07 03:32 AM
how can i call sub or function in vba code xxx Excel Discussion (Misc queries) 3 June 28th 06 11:47 AM


All times are GMT +1. The time now is 11:54 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"