My code below works, however when I try and copy / paste values, it doesnt like how I have .Sheets. I have also tried fName.Sheets. But says invalid qualifier.
How can I reference the sheet (fName) to copy/paste values?
Dim fName As String, Report As Workbook
Set Report = ActiveWorkbook
fName = Report.Worksheets(1).Range("A11").Text & ".xlsx"
If IsOpen(fName) Then
MsgBox "Good, file opened."
.Sheets("Avg Daily Vol").Range("G5").PasteSpecial xlValues
Application.CutCopyMode = False
MsgBox "Values pasted successfully!"
MsgBox "Today's report is currently not opened."