<div>
Hello Moore,<br />
<br />
you could try<br />
<br />
sheet1.ExportTabFile<br />
<br />
where sheet1 is the object name in the vb editor not the sheet tab name<br />
<br />
HAGD:O)Bruintje
</div>


Hello Moore,

you could try

sheet1.ExportTabFile

where sheet1 is the object name in the vb editor not the sheet tab name

HAGD:O)Bruintje

<div>
Opps :) Knew I had left something out. Suppose that what happens when you have not programmed for quite some time. tx
</div>


Opps :) Knew I had left something out. Suppose that what happens when you have not programmed for quite some time. tx

<div>
what was the answer ???<br />
<br />
<a href="https://www.experts-exchange.com/questions/20402975/Excel-2000-How-Do-you-call-a-sub-routine-in-a-different-worksheets.html" rel="ugc">https://www.experts-exchange.com/questions/20402975/Excel-2000-How-Do-you-call-a-sub-routine-in-a-different-worksheets.html</a>
</div>


what was the answer ???

https://www.experts-exchange.com/questions/20402975/Excel-2000-How-Do-you-call-a-sub-routine-in-a-different-worksheets.html [https://www.experts-exchange.com/questions/20402975/Excel-2000-How-Do-you-call-a-sub-routine-in-a-different-worksheets.html]

<div>
<div class="content wysiwyg-content">
This one has me stumped, how can one call a sub routine that is sitting in a different worksheet in the same workbook? e.g I am currently running a macro in my &quot;main&quot; worksheet and I want to call a sub routine that is sitting in my &quot;sub&quot; worksheet.<br />
<br />
Tried the following but it did not work:<br />
<br />
Call Sheets(&quot;CCS_Export&quot;).Expor<wbr />tTabFile<br />
<br />

</div>
</div>


This one has me stumped, how can one call a sub routine that is sitting in a different worksheet in the same workbook? e.g I am currently running a macro in my "main" worksheet and I want to call a sub routine that is sitting in my "sub" worksheet.

Tried the following but it did not work:

Call Sheets("CCS_Export").ExportTabFile



Excel 2000 - How Do you call a sub routine in a different worksheets?

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.