Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Opening Closed Worksheets with VBA
Please Help!
It seems like I have tried everything. I have a worksheet with a module that has the following VBA: Sub GetFile() Sheets("Menu").Select PathName = Range("C1").Value Filename = Range("C2").Value TabName = Range("C3").Value ControlFile = ActiveWorkbook.Name Workbooks.Open Filename:=PathName & Filename ActiveSheet.Name = TabName Sheets(TabName).Copy After:=Workbooks(ControlFile).Sheets(2) Windows(Filename).Activate ActiveWorkbook.Close SaveChanges:=False Windows(ControlFile).Activate Sheets("Menu").Select End Sub When I click the button on the sheet named "Menu" it opens the other workbook, but grabs the sheet that was last viewed before it was saved and closed. There are 2 sheets from the workbook I want to copy and paste when this button is clicked. How do I designate or tell Excel which exact tab to grab, and can I have 2 of them grabbed at the same time?? thanks!!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
linking worksheets to a closed workbook | Excel Worksheet Functions | |||
Closed toolbars keept re-opening | Excel Discussion (Misc queries) | |||
How to alter content in a closed spreadsheet without opening it! | Excel Discussion (Misc queries) | |||
Pull Data from a closed workbook, without opening it. | Excel Programming | |||
Code for Opening a Closed Workbook | Excel Programming |