ow to copy a sheet from another workbook to the active workbook?

**maytam** · 02-24-2014, 12:31 AM

I need a VBA to copy a sheet (usually named "sheet1") from another workbook (need to prompt select the workbook) to the active workbook, then allow to save as another name.

**patel45** · 02-24-2014, 02:46 AM

Please Login or Register  to view this content.

**maytam** · 02-24-2014, 03:09 AM

thanks patel45. It works.

ow to copy a sheet from another workbook to the active workbook?

LinkBack

Thread Tools

Rate This Thread

Display

ow to copy a sheet from another workbook to the active workbook?

Re: ow to copy a sheet from another workbook to the active workbook?

Re: ow to copy a sheet from another workbook to the active workbook?

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Copy active sheet to a new workbook

Copy active sheet to a new workbook

[SOLVED] COPY from an open workbook with particular sheet and columns to active workbook

[SOLVED] copy active sheet, create new workbook, name new workbook based on cell reference

[SOLVED] Copy active sheet from one workbook to another

Bookmarks

Bookmarks

Posting Permissions