-
Solved: Need help with copying data from another workbook
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?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules