Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 132
Default VBA code Required to Run the Multiple VBA Codes

Hi,

I am having 3 VBA Codings, 2 VBA codings are written in Module and the last
vba coding is written in THIS WORKBOOK. The 3 VBA Coding Names are

VBA Coding Names
FIRS_T
SECON_D
THIR_D

Now I want to write another coding in VBA to run that three vba codes. If I
run this new coding then it should run the above three VBA codes.

I dont know how to do it. Pls Suggest.

--------------------
(MS-Exl-Learner)
--------------------
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 71
Default VBA code Required to Run the Multiple VBA Codes

Sub RunAll
FIRS_T
SECON_D
THIR_D
end Sub

Robert Flanagan
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel


"MS-Exl-Learner" wrote in message
...
Hi,

I am having 3 VBA Codings, 2 VBA codings are written in Module and the
last
vba coding is written in THIS WORKBOOK. The 3 VBA Coding Names are

VBA Coding Names
FIRS_T
SECON_D
THIR_D

Now I want to write another coding in VBA to run that three vba codes. If
I
run this new coding then it should run the above three VBA codes.

I don't know how to do it. Pls Suggest.

--------------------
(MS-Exl-Learner)
--------------------



  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 132
Default VBA code Required to Run the Multiple VBA Codes

I am getting the below mentioned error message

Compile Error:
Sub or Function not defined

Please guide me.

--------------------
(MS-Exl-Learner)
--------------------



"Robert Flanagan" wrote:

Sub RunAll
FIRS_T
SECON_D
THIR_D
end Sub

Robert Flanagan
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel


"MS-Exl-Learner" wrote in message
...
Hi,

I am having 3 VBA Codings, 2 VBA codings are written in Module and the
last
vba coding is written in THIS WORKBOOK. The 3 VBA Coding Names are

VBA Coding Names
FIRS_T
SECON_D
THIR_D

Now I want to write another coding in VBA to run that three vba codes. If
I
run this new coding then it should run the above three VBA codes.

I don't know how to do it. Pls Suggest.

--------------------
(MS-Exl-Learner)
--------------------




  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,520
Default VBA code Required to Run the Multiple VBA Codes

Try the below

Sub RunAll()
FIRS_T
Secon_d
ThisWorkbook.Thir_d
End Sub


If this post helps click Yes
---------------
Jacob Skaria


"MS-Exl-Learner" wrote:

I am getting the below mentioned error message

Compile Error:
Sub or Function not defined

Please guide me.

--------------------
(MS-Exl-Learner)
--------------------



"Robert Flanagan" wrote:

Sub RunAll
FIRS_T
SECON_D
THIR_D
end Sub

Robert Flanagan
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel


"MS-Exl-Learner" wrote in message
...
Hi,

I am having 3 VBA Codings, 2 VBA codings are written in Module and the
last
vba coding is written in THIS WORKBOOK. The 3 VBA Coding Names are

VBA Coding Names
FIRS_T
SECON_D
THIR_D

Now I want to write another coding in VBA to run that three vba codes. If
I
run this new coding then it should run the above three VBA codes.

I don't know how to do it. Pls Suggest.

--------------------
(MS-Exl-Learner)
--------------------




  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 132
Default VBA code Required to Run the Multiple VBA Codes

Thank you it's working fine.

But now the VBA codes are Starting with Sub function only. If it is in Sub
Function then its working fine. But if i change the 3 VBA Macros as Private
Sub then it's showing the below error message.

Compile Error:
Method or data member not found

Thank you,

--------------------
(MS-Exl-Learner)
--------------------



"Jacob Skaria" wrote:

Try the below

Sub RunAll()
FIRS_T
Secon_d
ThisWorkbook.Thir_d
End Sub


If this post helps click Yes
---------------
Jacob Skaria


"MS-Exl-Learner" wrote:

I am getting the below mentioned error message

Compile Error:
Sub or Function not defined

Please guide me.

--------------------
(MS-Exl-Learner)
--------------------



"Robert Flanagan" wrote:

Sub RunAll
FIRS_T
SECON_D
THIR_D
end Sub

Robert Flanagan
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel


"MS-Exl-Learner" wrote in message
...
Hi,

I am having 3 VBA Codings, 2 VBA codings are written in Module and the
last
vba coding is written in THIS WORKBOOK. The 3 VBA Coding Names are

VBA Coding Names
FIRS_T
SECON_D
THIR_D

Now I want to write another coding in VBA to run that three vba codes. If
I
run this new coding then it should run the above three VBA codes.

I don't know how to do it. Pls Suggest.

--------------------
(MS-Exl-Learner)
--------------------





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
Changes Required In Macro Code TGV Excel Discussion (Misc queries) 2 February 10th 09 05:53 PM
Another VB Code Required TGV Excel Discussion (Misc queries) 7 February 7th 09 07:21 AM
VB Code Required TGV Excel Discussion (Misc queries) 3 February 6th 09 05:31 PM
macro code required muddan madhu Excel Worksheet Functions 2 April 28th 08 03:43 PM
help required in completing the code deepika :excel help[_2_] Excel Discussion (Misc queries) 0 February 26th 08 09:15 AM


All times are GMT +1. The time now is 09:45 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"