Here's a VBA script that opens a workbook and then saves it to the desktop. I have no idea what I did wrong.
Question 2: does my procedure location matter? (i.e. Should this be in location 1, 2, or 3?) (See graphic below).
Dim TargetWorkbook As String
Dim DTAddress As Object
Dim wb As Workbook
TargetWorkbook = "C:\summary.xlsx"
Set wb = Workbooks.Open(TargetWorkb
DTAddress = CreateObject("WScript.Shel
Desktop") & Application.PathSeparator
wb.SaveAs (DTAddress & "summary.xlsx")