Copying a worksheet from a different workbook without using the clipboard - values only

**gsmcconville** · 01-14-2016, 04:01 AM

Can anybody please let me know if it is possible to...

Copy a worksheet from a different workbook to a worksheet in the current workbook, without using the clipboard, and by copying values only, and doing it with only one line of code please.

So far I am using this, but it copies formatting as well, which I do not want.

Please Login or Register  to view this content.

I can remove the formatting with extra lines of code, but would like to know if it is possible with just a single instruction.

Thank you

**joe31623** · 01-14-2016, 04:15 AM

Can't you do the following?

Set WBD.WSD = WBS.WSS

Or

Set WSD = WSS
?

**joe31623** · 01-14-2016, 04:19 AM

Else, I wonder if you can activate the source worksheet, store the worksheet in a collection, and then activate the destination workbook, create a new worksheet, and copy the worksheet contained in the collection to the destination worksheet using a Set method.

Never tried either method and I'm away from my computer right now but please let me know if either this way or something in my last post worked.

I can provide code tomorrow if you aren't familiar with collections.

Joe

**gsmcconville** · 01-14-2016, 04:23 AM

No, it does not work.

I have decided to use this.

Please Login or Register  to view this content.

It stops the numbers being copied over as text, just does not do it in one line.

Good enough.

Thanks anyway.

**joe31623** · 01-14-2016, 01:58 PM

See the following for a solution: http://www.excelforum.com/excel-prog...rng-cells.html

**joe31623** · 01-14-2016, 02:00 PM

You basically need a structure like this, but it could be problematic when dealing with extremely large data sets

Please Login or Register  to view this content.

Copying a worksheet from a different workbook without using the clipboard - values only

LinkBack

Thread Tools

Rate This Thread

Display

Copying a worksheet from a different workbook without using the clipboard - values only

Re: Copying a worksheet from a different workbook without using the clipboard - values onl

Re: Copying a worksheet from a different workbook without using the clipboard - values onl

Re: Copying a worksheet from a different workbook without using the clipboard - values onl

Re: Copying a worksheet from a different workbook without using the clipboard - values onl

Re: Copying a worksheet from a different workbook without using the clipboard - values onl

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Copying a worksheet from a workbook and save it as a new worksheet based on a list. VBA

Copying Rows to clipboard from a range if they have values

Copying Data from Worksheet of 1 Workbook to a worksheet in another workbook

[SOLVED] Copying worksheet from another open workbook using variables, paste to active workbook

Copying filtered data from one worksheet to a worksheet in another workbook

Copying named worksheet from a workbook to a new workbook

Copying A Worksheet From Each Open Workbook to an new Workbook

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions