Insert existing worksheet into workbook

**shg** · 10-18-2008, 06:49 PM

Worksheets.Add Type:="C:\somePath\the file I saved earlier.xls"

**Salomon** · 10-18-2008, 07:16 PM

Thanks for the help. I tried it but I get an error: Run-time error '1004': Method 'Add' of object 'Sheets' failed. Any idea?

**shg** · 10-18-2008, 07:21 PM

Did you change the path and filename as appropriate?

**Salomon** · 10-18-2008, 07:32 PM

I'm pretty sure. I've looked at through debugger. I even tried to use a hard coded path instead but no luck.

**shg** · 10-18-2008, 07:42 PM

Hmm. Try

Sheets.Add Type:="C:\somePath\the file I saved earlier.xls"

**Salomon** · 10-18-2008, 08:20 PM

Exactly the same error!!!

I'm obviously doing something wrong but what?

**Salomon** · 10-18-2008, 08:24 PM

Got it. It's:
Sheets.Add Type:="C:\somePath\the file I saved earlier"

Weird. Thank you!

RE: Insert existing worksheet into workbook