I am using the following code to create a duplicate of an active file and then close the active file. But I am struggling to open the file I just created. Will appreciate some hand holding.

I don't believe this is creating a duplicate of the active file.
When you save it with a different name the original will be abandon in its last saved state and
you will automatically now be working with the newly named and saved file in the current state.
If that is your desire, don't close the active workbook.

OR

Are you saying that you can't find the newly saved file after closing it ?
If so, those empty double quotes may be the issue.

You are spot on with your observation. When I removed close code it worked. following is the code I am using now.

Sub Copy()

Dim strFilename As String, D As Workbook ', K As Workbook

Set D = ActiveWorkbook

strFilename = D.Path & "\GJCT Roster Week " & Range("sWeekNo") + 1 & " WS " & Range("sWeekStart") + 7 & ".xlsm"

D.SaveCopyAs Filename:=strFilename


Workbooks.Open (strFilename)

D.Close

End Sub

Only one thing I am now confronted with is the need to replace named ranges to the values I am renaming the file to in the above statements (sWeekNo and sWeekStart). In nutshell I would like the newly created file to show the new week number and week start date as reflected in the file name. Could the be extracted from file name?

Use variables, something along the lines of this.
Had to format the date to eliminate forward slashes which are illegal in the file name.

@kwhaja
Please wrap your code with code tags ( the #button)
Thanks

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

I am very grateful for your assistance. It works great and in the manner I envisaged. You are a star.