Hi
Thanks for reading my post.
I am trying to open and close a workbook from an active workbook but my code has a bug which i can figure out.
Your help is appreciated, thank you.
Sub Import()
Dim wbkOpenClose As Workbook
Dim wksINPUT As Worksheet
Dim wbkCurrentFileLocation As Workbook
Set wbkOpenClose = ActiveWorkbook
Set wksINPUT = wbkOpenClose.Sheets("INPUT")
Set wbkCurrentFileLocation = Workbooks.Open(Filename:=wksINPUT.Range("Current_File_Location").Value)
wbkCurrentFileLocation.Close (False)
End Sub
Bookmarks