Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Sub UploadData()
- Dim Model As Workbook
- Dim Q As Workbook
- Dim rngFX As Range
- Dim Year As String
- Set Model = ActiveWorkbook
- Set Q = Workbooks.Open(Filename:=Sheets("Instructions").Range("$C$29").Value)
- Month = ("C" & (Model.Sheets("Instructions").Range("$C$23")))
- With Q
- With .Sheets(Month & " Summary")
- Set rngFX = .Range("A61:R66")
- rngFX.Copy Destination:=Model.Sheets("FOREX Forecast").Range("A3")
- End With
- End With
- Q.Close savechanges:=False
- With Model.Sheets("FOREX Forecast").UsedRange
- .Value = .Value
- End With
- End Sub
Add Comment
Please, Sign In to add comment