Open a specific sheet with VBA

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi I was wondering what the VBA code was for opening a specific sheet in
another unopen workbook.

For example from one workbook I want to open sheet6 on another one

my code is beneath

Workbooks.Open "\\Kerrygriffit-pc\external\Other\Money\New Going out Sheet
V2.xls\february"

Thanks Joel
 
One way:


Workbooks.Open "\\Kerrygriffit-pc\external\Other\Money\New Going out
Sheet V2.xls\february"
ActiveWorkbook.Sheets("Sheet6").Activate
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Code execution is correct but generates Error :The file you aretrying to open is in a different form 3
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Help with activating window from Application.GetOpenFilename 4
Open four Wbooks, copy four columns from each to Master Wbook 16
Unable to change ActiveSheet within Workbook_Open 2
How do assign a name to a remote workbook ? 3
Copy ranges from several sheets to another one in a vertical position 1
Error Opening Workbook 3

Back
Top