V
vbidiot
I have the following code but I'm having trouble pulling the specific
worksheet instead of the entire workbook. e.g I want to pull sheet 2
from the workbook.
Code:
--------------------
Sub DataAcquire2A()
Dim RngToCopy As Range
Dim wkbk As Workbook
Dim DestCell As Range
Dim myFileNames As Variant
Dim iCtr As Long
Dim testStr As String
Set DestCell = ThisWorkbook.Worksheets(1).Range("a1:J1")
myFileNames = Array("S:\LOOSELEAF UPDATES\LOOSELEAF FILER INPUT\LOOSELEAFFIX.XLS", _
"S:\LOOSELEAF UPDATES\LOOSELEAF FILER INPUT\LOOSELEAFFIX2.XLS")
worksheet instead of the entire workbook. e.g I want to pull sheet 2
from the workbook.
Code:
--------------------
Sub DataAcquire2A()
Dim RngToCopy As Range
Dim wkbk As Workbook
Dim DestCell As Range
Dim myFileNames As Variant
Dim iCtr As Long
Dim testStr As String
Set DestCell = ThisWorkbook.Worksheets(1).Range("a1:J1")
myFileNames = Array("S:\LOOSELEAF UPDATES\LOOSELEAF FILER INPUT\LOOSELEAFFIX.XLS", _
"S:\LOOSELEAF UPDATES\LOOSELEAF FILER INPUT\LOOSELEAFFIX2.XLS")