Hi friends,
I am suing below VBA to open, save and close other files. I want to put File destination ("C:\Dropbox\RGPLSG 6\Exports - Sales - 1 - 2017\Exports - Sales - 1 - Helper - 2017.xlsm") in Excel cells like in Sheet1!A1, So that easyly I can change destination when every I want.
Please make changes in below vba.
Option Explicit
Sub Update()
Application.ScreenUpdating = False
Application.DisplayStatusBar = False
Application.EnableEvents = False
Dim link1 As Workbook
Set link1 = Workbooks.Open("C:\Dropbox\RGPLSG 6\Exports - Sales - 1 - 2017\Exports - Sales - 1 - Helper - 2017.xlsm")
link1.Close savechanges:=True
Application.ScreenUpdating = True
Application.DisplayStatusBar = True
Application.EnableEvents = True
End Sub
Thank you
Bookmarks