doctortt
05-06-2011, 09:45 AM
I'm a newb, struggling with copying data from another workbook. Can someone help me out
OpenFile = Application.GetOpenFilename(FileFilter:="Excel files(*.xls), *.xls")
This code will bring up the open file prompt and after the user select the .xls file, how do I copy all data on a worksheet called Data to the active workbook that i'm working on?
OpenFile = Application.GetOpenFilename(FileFilter:="Excel files(*.xls), *.xls")
This code will bring up the open file prompt and after the user select the .xls file, how do I copy all data on a worksheet called Data to the active workbook that i'm working on?