Hi Friends,
I want to open excel sheet from the folder then needs to create new workbook and I need copy some data from opend workbook to newly created workbook.
Please kindly help me with code.
Thanks & Regards
Ramesh
Hi Friends,
I want to open excel sheet from the folder then needs to create new workbook and I need copy some data from opend workbook to newly created workbook.
Please kindly help me with code.
Thanks & Regards
Ramesh
You will have to be more specific about what you are trying to do.
You want to open a closed workbook and copy data from it and paste it into a new workbook?
Where is the code to be run from?
What data and/or how many sheets get's copied to the new workbook?
Have you made any efforts on your own that you can show us as a starting point?
Steve
"Nearly all men can stand adversity, but if you want to test a man's character, give him power."
-Abraham Lincoln
Here's a thread that shows how to copy data from one workbook to a newly added worksheet.
http://www.vbaexpress.com/forum/showthread.php?t=20128
Steve
"Nearly all men can stand adversity, but if you want to test a man's character, give him power."
-Abraham Lincoln