Excel VBA Code Problem

[abdullahsikandar]

Hello......


Can you all tell me please how do i select one sheet from 2 sheets in excel.

For example:

I need to select to search for a name of sheets from 3 sheets.

Worksheets("Seet2" or "Seet4")
Can i do like that?

 

[Joe4]

What exactly are you trying to do?

Depending on what you are trying to do, you may need to select them one at a time. You could do this is a loop, i.e.

    Dim ws As Worksheet
    
    For Each ws In Worksheets
        If (ws.Name = "Sheet2") Or (ws.Name = "Sheet4") Then
            ws.Activate
            ' [I]your code here[/I]
        End If
    Next ws

 

[abdullahsikandar]

Set oWS(i) = oWB(i).Worksheets("Hello")

I am setting this to take only sheet Hello and i need it to take either the sheet Hello or sheet Hi.

 

[Joe4]

Why? What are you trying to do with it? What is the "end goal" here?
If oWS is a worksheet variable, I don't believe it can be set to multiple worksheets simultaneously.

If we know what you are trying to accomplish, we may be able to suggest alternatives.

 

[abdullahsikandar]

Why? What are you trying to do with it? What is the "end goal" here?
If oWS is a worksheet variable, I don't believe it can be set to multiple worksheets simultaneously.

If we know what you are trying to accomplish, we may be able to suggest alternatives.

Well, I am Importing all the excel files into the Database, So what i need is that when it is importing from excel so it will search from 2 sheets which one sheet name is available it will take the data from anyone of them.

 

[Joe4]

Well, I am Importing all the excel files into the Database, So what i need is that when it is importing from excel so it will search from 2 sheets which one sheet name is available it will take the data from anyone of them.

I don't think that is quite clear, probably because we do not know the details of your project like you do.

All what Excel files? Is there a folder full on Excel files you are importing?
Into what Database? Is the Database in Excel, Access, SQL, etc?
Are you searching sheets on the file you are copying FROM, or the database you are copying TO?
What exactly are you searching for, and what are you doing with it when you find it?