Creating a new workbook, copying sheets & saving workbook - Subscript error

**amphinomos** · 05-30-2014, 08:36 AM

Hi,

Trying to create a new workbook from another open workbook, then copying all the sheets that aren't called "Summary" to that new open workbook and then saving it. I get a subscript error on this line:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Any ideas ?

Thanks!
amphi

**Miroslav R.** · 05-30-2014, 08:47 AM

Hi there,
is Your source workbook name "MergeMacro"?

Also look at this row:

Please Login or Register  to view this content.

Better use:

Please Login or Register  to view this content.

When I copy Your code to my workbook, works as it should...

**amphinomos** · 05-30-2014, 08:51 AM

Thanks for picking that up Miroslav. Still isn't working on my side...

Edit: Found what was missing. Had to specify the file extenstion:

Please Login or Register  to view this content.

**Miroslav R.** · 05-30-2014, 09:04 AM

Man,
we forgot one basic thing - where is the extension *.xlsm / *.xls?

Please Login or Register  to view this content.

Creating a new workbook, copying sheets & saving workbook - Subscript error

LinkBack

Thread Tools

Rate This Thread

Display

Creating a new workbook, copying sheets & saving workbook - Subscript error

Re: Creating a new workbook, copying sheets & saving workbook - Subscript error

Re: Creating a new workbook, copying sheets & saving workbook - Subscript error

Re: Creating a new workbook, copying sheets & saving workbook - Subscript error

Thread Information

Users Browsing this Thread

Similar Threads

Getting 1004 error while copying data from sheets to master tab in the workbook

[SOLVED] Consolidate multiple workbook sheets to one file - subscript out of range error?????

[SOLVED] Closing a Workbook from another workbook: Workbooks.close error: Subscript out of range

Copying sheets to a new workbook and saving it.

creating new workbook and copying sheets to it

Bookmarks

Bookmarks

Posting Permissions