I already wrote a code to open a file and run the Macro. But im just having trouble saving it and closing it. I tried the function Workbooks.close but this closes all of my open workbooks, I just want to close that specific one.
Here's what I have so far.
![]()
Sub Transfer_Replace() aux = Application.GetOpenFilename("File, *.*") ' open workbook if Cancel wasn't pressed If aux <> False Then Workbooks.Open aux '''Call Macro Replace1 End Sub
Bookmarks