Hi,

I think this is a fairly simple question, but I'm still new at this and so I don't know the answer. I have the below I'm using to enable the user to choose a file from a dialog box:

With Application.FileDialog(msoFileDialogFilePicker)
   .AllowMultiSelect = False
   .Title = "Select Source Portfolio"
   .InitialFileName = "Z:\_New Folder Structure\Reporting\Optimizations"
   If .Show = -1 Then
   'ok clicked
   SourcePortfolio = .SelectedItems(1)
   Workbooks.Open (SourcePortfolio)
   Else
        MsgBox "Portfolio Not Selected"
        Exit Sub
   End If
   'cancel clicked
End With
I'd like to take columns A:AW of the "Test" sheet on the workbook selected by the user and paste it into "This Workbook" same sheet and range. I'm attempting this using the below:

Workbooks.("SourcePortfolio").Worksheets("Test").Range("A:AW).Copy ThisWorkbook.Worksheets("Test").Range("A:AW")
That clearly doesn't work. Is the problem here that while the user has chosen the portfolio, "SourcePortfolio", the user has actually NOT chosen the exact path, so my Workbooks code above is not working. If that's the case, can someone please advise how I can fix it?

Thanks!