#1   Report Post  
Posted to microsoft.public.excel.misc
Joe
 
Posts: n/a
Default macros embedded

Hi,

I have (in the same workbook), four macros:

Sub autoread ( )
Sub filterdata ( )
Sub splitdata ( )
Sub viewresults ( )

what I would like to have is one single macro, lets say,

sub mymacro ( )

and when I run this new macro, it should "call" the other four macros
and run them.

Conceptually,

Sub mymacro ( )
--------------
------------
(run) Sub autoread ( )
-----------
(run) Sub filterdata ( )
----------
(run) Sub splitdata ( )
----------
(run) Sub viewresults ( )
------------
End Sub


Is this possible, and if yes, could anyone please help me with this ?

Thanks,

- Joe.

  #2   Report Post  
Posted to microsoft.public.excel.misc
JMay
 
Posts: n/a
Default macros embedded

How 'bout:

Sub mymacro
Call autoread
Call filterdata
Call splitdata
Call viewresults
End Sub


"Joe" wrote in message
oups.com...
Hi,

I have (in the same workbook), four macros:

Sub autoread ( )
Sub filterdata ( )
Sub splitdata ( )
Sub viewresults ( )

what I would like to have is one single macro, lets say,

sub mymacro ( )

and when I run this new macro, it should "call" the other four macros
and run them.

Conceptually,

Sub mymacro ( )
--------------
------------
(run) Sub autoread ( )
-----------
(run) Sub filterdata ( )
----------
(run) Sub splitdata ( )
----------
(run) Sub viewresults ( )
------------
End Sub


Is this possible, and if yes, could anyone please help me with this ?

Thanks,

- Joe.



  #3   Report Post  
Posted to microsoft.public.excel.misc
Joe
 
Posts: n/a
Default macros embedded

Thank you very much. That was really easy. :)

- Joe.

Reply
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
Excel crashes while opening excel file imbeddied with macros ct2147 Excel Discussion (Misc queries) 0 December 30th 05 10:05 PM
Displaying cell references next to embedded cells in Word 2000 The Consigliere New Users to Excel 1 April 9th 05 03:58 PM
Enabling macros Peter M Excel Discussion (Misc queries) 3 February 7th 05 11:57 PM
sorting with macros Sorting in macros Excel Discussion (Misc queries) 1 February 1st 05 10:02 AM
Transferring toolbars and macros to other computers Darrell Excel Discussion (Misc queries) 1 January 19th 05 01:21 AM


All times are GMT +1. The time now is 02:35 AM.

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"