Hi TButhe
One way that springs to mind is to use an Input Box and get the user to tell you their file name. You assign that to a variable and you can use it in your code to reference that particular workbook. You wouldn't need to switch back and forth - just refer directly to the variable. Perhaps something like this
Sub GetAFile()
Dim strOldFile
strOldFile = Application.GetOpenFilename(filefilter:="Excel Files (*.xls),*.xls", Title:="Select your file")
If strOldFile = False Then Exit Sub
Workbooks.Open Filename:=strOldFile
End Sub
You can add a command button like this
Sub AddAButton()
Dim ole As OLEObject
With ActiveSheet
Set ole = .OLEObjects.Add(Classtype:="Forms.CommandButton.1", Left:=10, Top:=20, Height:=25, Width:=75)
With ole.Object
.Caption = "Click to begin transfer"
.OnAction = "RunMyMacro"
End With
End With
End Sub
You would need to play around with the Top and Left settings to work out exactly where it would go on your sheet.
Hope this gives you some ideas.
Regards