Open Workbook and Activate Sheet1

[mikec007]

I have a userform that the user will input the file location of the excel file to open.

How do I open that file, and activate Sheet1 of that file. I will not know that exact name of the first sheet in the newly opened excel workbook so I have to use the Sheet1.

I have the code:

Application.Workbooks.Open xlxlocation.Text

Sheets(Sheet1).Activate

But it errors about because there are two Sheet1. (one from the excel file with the userform program and one from the newly opened excel file. How do it tell it to activate the sheet1 from the xlxlocation.text location.

xlxlocation.text = full file name (C:/ahldfl/asldjfd/workbook.xls)

I know it is something simple but I cannot figure it out. I think you may have to use "With" but i am just beginning.

 

[VoG]

Try

Workbooks.Open xlxlocation.Text
ActiveWorkbook.Sheet1.Activate

 

[mikec007]

Try

Workbooks.Open xlxlocation.Text
ActiveWorkbook.Sheet1.Activate

It keeps giving me an mismatch error. I tryed both your code and :

ActiveWorkbook.Sheets(Sheet1).Activate

Both error out. I have tried screenupateing true and false. Nothing works.

It is like it doesnt activate the the workbook when its opened.

 

[VoG]

How about

ActiveWorkbook.Sheets(1).Activate

 

[mikec007]

How about

ActiveWorkbook.Sheets(1).Activate

That worked. Why does VBA do this?