Help write code to Import/Export worksheets

**emptycucumber** · 06-03-2009, 12:36 AM

Does anyone have time to write me a code to Import/Export worksheets?

I would really appreciate it!

Nothing fancy

**royUK** · 06-03-2009, 03:18 AM

Your question is vague. This will copy the activesheet to a new workbook.

Please Login or Register  to view this content.

Give us some more inormation for more help You could try the macro Recorder

http://www.excel-it.com/record_macro.htm

**emptycucumber** · 06-03-2009, 09:03 AM

Say I have a workbook, I want to Export only certain worksheets which I will Import into an "updated" version of the current workbook.

**shg** · 06-03-2009, 09:55 AM

Please Login or Register  to view this content.

**emptycucumber** · 06-03-2009, 10:54 AM

Originally Posted by shg

Please Login or Register  to view this content.

Hey, it's Exporting fine, but I get an error at the end.

Please Login or Register  to view this content.

What do you think is causing the Debug error?

Also, what would the code be for Importing?

Re: Help write code to Import/Export worksheets