PDA

View Full Version : how to open a existing worksheet from certain folder and creating new workbook



ramserp
04-22-2010, 09:19 PM
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
04-23-2010, 06:19 AM
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
04-23-2010, 06:22 AM
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