Excel Exporting Info Question 1

[SandraF]

I have the following code in a macro in an excel workbook:

Set wbMaster = ThisWorkbook

Workbooks.Open "E:\DBTest.xls"
Set wbTemp = ActiveWorkbook

For Each ws In Worksheets
Select Case ws.Name

The problem is that when I do the for loop, I want it to look in the wbMAster file, and not the wbTemp file because the MAster file is where I need to first get the data and send it to the wbTemp file. Is there something that I can do to make it so?

THANKS

 

[dsi]

Use the worksheets collection for the master workbook.

For Each ws In wbMaster.Worksheets