Hello all,

Attempting to run a macro from workbook A ("Feedback_View_(Perspective)_2013-03-04-0950.csv") where data from workbook B ("Helper.xlsx") is copied and pasted into a new worksheet named "Helper" in workbook A. Here is my code so far:

Sub proGetHelper()

ThisWorkbook.Activate
Sheets.Add.Name = "Helper"
Sheets("Helper").Select

Workbooks.Open Filename:="C:\...\Helper.xlsx", ReadOnly:=True

Workbooks("Helper.xlsx").Activate
Sheets(1).Select
Range("A1:H46").Copy

Workbooks("Feedback_View_(Perspective)_2013-03-04-0950.csv").Activate
Sheets("Helper").Select

[a1].PasteSpecial Paste:=xlPasteValues
[a1].Select

Application.CutCopyMode = False

Workbooks("Helper.xlsx").Close

End Sub
This code works, however I would like it to work for other "destination" files, which will have a different date/time stamp.

Any help would be much appreciated!