VBA across worksheets

[RicksAtWork]

I have a workbook (W1) that has a bunch of methods.

The same workbook creates a new workbook (W2).

In a macro on W1 I want to execute another macro held on W1 but this must operate upon W2 ie.e

Windows("W2").Activate
W1Macro(WorkSheet(worksheetinW2))


But this doesnt work!

 

[SkipVought]

Workbooks("W2").Worksheets("Sheet1").Cells(1,1).value = "Hello"

Skip,

_{[red]Be Advised![/red]
The band of elderly oriental musicians, known as Ground Cover, is, in reality...
Asian Jasmine!}

 

[RicksAtWork]

So if I want to run the macro held in workbook1 on a sheet in Workbook2 I would have guessed that this would have worked.

Workbooks(KOLWorkSheetFilename).ApplyDesign Workbooks(ExportWorkSheetFilename).Worksheets(CStr(country))

It doesnt! ApplyDesign is my macro which accepts a worksheet

Any ideas???

 

[SkipVought]

Please post your complete code

Skip,

_{[red]Be Advised![/red]
The band of elderly oriental musicians, known as Ground Cover, is, in reality...
Asian Jasmine!}

 

[PHV]

Have you tried somethis like this ?
Call ApplyDesign(Workbooks(ExportWorkSheetFilename).Worksheets(CStr(country)))

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[RicksAtWork]

Genius!