How to add existing sheet to an opened workbook?

[hegisin]

Hi,

I've an open workbook (open.xls) that contains a number of sheets.

I also have an saved workbook with the name "saved.xls" which is a single sheet.

Now, I want a command that adds "saved.xls" to "open.xls" and renames it to "Sheet1".

How would I have to do it?

Any ideas are greatly appreciated.

Cheers,
hegisin

[VBA Noob]

Select "saved.xls" > right click sheet tab > select Move or copy > with the to book dropdown select "open.xls" > click ok.

Then rename as required

http://www.bettersolutions.com/excel...T423111411.htm

VBA Noob

[hegisin]

Hi VBA Noob,

Thanks for your reply.

I know about this option but don't like to do it that way because my "saved.xls" sheet contains a web query. If I use the "move" function then the web query cannot refresh its data anymore.

Therefore I would like to open the existing "saved.xls" sheet directly in the "open.xls" workbook.

Is there any way to do that?

Cheers,
hegisin

[VBA Noob]

Sorry with code it might be something like

Please Login or Register  to view this content.

Amended
Is the same as the manual way so you will have the same problem.
Change

Please Login or Register  to view this content.

to activesheet if you don't know the name

VBA Noob

[hegisin]

Mmh, that also just moves the worksheet and I lose the web query refresh ability.

I believe the "saved.xls" sheet must be opened directly within the "open.xls" workbook.

[VBA Noob]

Start a new thread with a title that describes the problem. I answered your original question which has nothing to do with what your trying to do

suggest title. "Retain links when moving a web query sheet to a another book"

VBA Noob