July 11, 2020
I have written a code that opens an excel file based upon the path provided, but the new excel get open as a new worksheet, Can it be opened as another sheet in the same workbook?
Kindly help me with the modification in the code as attached. Cell D4 contains the address of the file that i want to open.
Dim my as string
December 20, 2019
Its much easier if you add a workbook rather than paste in a peice of code
Add ActiveSheet.Move before:=Workbooks("OpenFile.xlsm").Sheets(1) after you open in and delete the activeworkbook.close
Dim my As String
my = Range("d4").Value