hsduk101
03-10-2007, 12:13 AM
All,
Im want to import sheet2 from workbook B into sheet1 in workbook A.
How do I do this. I was thinking of using the Application.Dialogs(xlDialogOpen) Function.
The reason that I want to use the xlDialogueOpen is because the sheet I am importing is not fixed and can be from any file.
As I said earlier I only want to import a sheet and not the entire workbook.
Also If I could choose which sheet I want to import then that would be better
Please help, I am a novice at VBA
Im want to import sheet2 from workbook B into sheet1 in workbook A.
How do I do this. I was thinking of using the Application.Dialogs(xlDialogOpen) Function.
The reason that I want to use the xlDialogueOpen is because the sheet I am importing is not fixed and can be from any file.
As I said earlier I only want to import a sheet and not the entire workbook.
Also If I could choose which sheet I want to import then that would be better
Please help, I am a novice at VBA