how to open a existing worksheet from certain folder and creating new workbook

[ramserp]

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

[lucas]

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?

[lucas]

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