| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Import from another Workbook
You have another response in .excel
dan wrote: In Workbook 1, I am running a macro that uses this code to select a file and copy A:Z on the main worksheet: Dim myBk As Workbook Set myBk = Workbooks.Open(Application.GetOpenFilename _ (, , "Select the file")) Sheets("Main").Select Range("A:Z").Copy Next, I want it to switch back to Workbook 1, insert a new worksheet, paste the data, and name the worksheet "rawdata". Any suggestions for me? I basically have a workbook I'm starting from, I want to open a dialog box to allow the user to select another excel file (filenames can be different so I want user to select), and then import a specific worksheet from that workbook into my starting workbook. Any help would be greatly appreciated, Thanks! Dan -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Import worksheets from another workbook? | Excel Worksheet Functions | |||
| How do I import one workbook into another? | Excel Discussion (Misc queries) | |||
| IMPORT DATA from the same Workbook | Excel Discussion (Misc queries) | |||
| Import/Copy some data from one workbook to a similar workbook | Excel Programming | |||
| How do I import an XLT worksheet into another workbook? | Excel Programming | |||
Hybrid Mode
