Hallo all,
I am trying to copy an array of Worksheets from one given Workbook to another Without saving the File.
become a Error :-
Runtime error 9:
Subscript out of range
in the code line:
Code
Sheets(Array("BMW 525 d Limousine", "BMW 318d touring ", "VW Passat", _
"Golf Lim.")).Copy Before:=Workbooks("wbreport").Sheets(1)
OR:
run time Error 424
Object required
By following code Change?
I have searched the web for a answer, but they all seam to want to save the File afterwards?
This is not what I wish to do, I require a mirror immage of selected (5 Variables) Sheets into a differant Workbook Tempolaraly without saving it.
Has anyone the solution? I am still using Excel 2007
For all help i thankyou in advance
Ray
Code
Sub Group1()
Dim kopie As Variant
Dim Sheet1 As Worksheet
Dim wbReport, wbPolicy As Workbook
Set wbPolicy = Workbooks.Open("\\demscfs012.group.com\data\Distribution\wagen\Cars.xls")
Sheets(Array("BMW 525 d Limousine", "BMW 318d touring ", "VW Passat", _
"Golf Limousine")).Copy Before:=Workbooks(wbreport).Sheets(1)
wbReport.Activate
Display More