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

a_moore
a_moore used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2006

Commented:
a_moore,

Instead of
   Sheets("CCS_Export").ExportTabFile
use the code name of CCS_Export, eg
   Sheet1.ExportTabFile

Regards,
Sébastien

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial