Dim xlsPath As String
xlsPath = "C:\"
Workbooks(xlsPath & "Output.xls").Sheets("Output").Range("B2:B6").Copy
I am trying above code for this but getting error.
Asked
Active
Viewed 102 times
0
-
What error do you get? You cannot copy from a closed workbook. Why not open it? – Tim Williams Mar 04 '14 at 17:47
-
error is Subscript out of range. I am automating a process so I dont want to open a excel during that process. – RDP Mar 04 '14 at 17:48
-
you can make open it and make it invisible to users – Dmitry Pavliv Mar 04 '14 at 17:50
-
Probably that sheet "Output" does not exist. – simpLE MAn Mar 04 '14 at 19:00
2 Answers
0
In order to reference the Workbook xlsPath & "Output.xls", it needs to already be opened in Excel. This is explained in the Workbook Object definition here.
... the workbook must already be open in Microsoft Excel.
What you probably want to do is use the ExecuteExcel4Macro function as was previously answered here.
-
Resolved -- I tried below code to access data without opening another excel. Application.ScreenUpdating = False Workbooks.Open Filename:="C:\Output.xls" Workbooks("Input.xls").Worksheets("abc").Activate .............. .............. Workbooks("Output.xls").Close SaveChanges:=False – RDP Mar 05 '14 at 16:36
-
Ok, I answered based on your question - how to do this without opening it. You obviously just meant you didn't want to see it when it was opened. Good job figuring that out. – farvgnugn Mar 07 '14 at 16:06
0
Resolved -- I tried below code to access data without opening another excel.
`Application.ScreenUpdating = False Workbooks.Open Filename:="C:\Output.xls" Workbooks("Input.xls").Worksheets("abc").Activate
Workbooks("Output.xls").Close SaveChanges:=False`
RDP
- 81
- 2
- 13