........
........
Range("O2").Select
[b]ActiveCell.FormulaR1C1 = "110"
[/b]
Range("P2").Select
[b]ActiveCell.FormulaR1C1 = "110"
[/b]
Range("P3").Select
Application.Run "SL_Test_Dukascopy_.xlsm!Macro3"
Sheets("DB").Select
Range("B3:AE700025").Select
ActiveSheet.Range("$B$2:$AE$700025").AutoFilter Field:=1, Criteria1:="<>"
Selection.Copy
Workbooks.Open Filename:="C:\Users\utente\Desktop\Portafoglio Post news.xlsm"
Sheets("Portafoglio globale").Select
Range("A12").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Workbooks.Open Filename:="C:\Users\utente\Desktop\Ottimizzazione_.xlsm"
Sheets("Dati").Select
[b]Range("A4500").Select
[/b]
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Windows("Portafoglio Post news.xlsm").Activate
Sheets("Sintesi ").Select
Range("D2:D36").Select
Application.CutCopyMode = False
Selection.Copy
Windows("Ottimizzazione_.xlsm").Activate
Sheets("DB Ottimizzazioni").Select
[b]Range("L73").Select
[/b]
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Application.CutCopyMode = False
ActiveWorkbook.Save
ActiveWindow.Close
Sheets("Portafoglio globale").Select
Application.Run "'Portafoglio Post news.xlsm'!Macro1"
ActiveWorkbook.Save
ActiveWindow.Close
ActiveSheet.Range("$B$2:$AE$700025").AutoFilter Field:=1
Sheets("Test").Select
Application.Run "SL_Test_Dukascopy_.xlsm!Macro2"
Range("O2").Select
[b]ActiveCell.FormulaR1C1 = "25"
[/b]
Range("P2").Select
[b]ActiveCell.FormulaR1C1 = "120"
[/b]
Range("P3").Select
Application.Run "SL_Test_Dukascopy_.xlsm!Macro3"
Sheets("DB").Select
Range("B3:AE700025").Select
ActiveSheet.Range("$B$2:$AE$700025").AutoFilter Field:=1, Criteria1:="<>"
Selection.Copy
Workbooks.Open Filename:="C:\Users\utente\Desktop\Portafoglio Post news.xlsm"
Sheets("Portafoglio globale").Select
Range("A12").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Workbooks.Open Filename:="C:\Users\utente\Desktop\Ottimizzazione_.xlsm"
Sheets("Dati").Select
[b]Range("A4650").Select
[/b]
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Windows("Portafoglio Post news.xlsm").Activate
Sheets("Sintesi ").Select
Range("D2:D36").Select
Application.CutCopyMode = False
Selection.Copy
Windows("Ottimizzazione_.xlsm").Activate
Sheets("DB Ottimizzazioni").Select
[b]Range("M73").Select
[/b]
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Application.CutCopyMode = False
ActiveWorkbook.Save
ActiveWindow.Close
Sheets("Portafoglio globale").Select
Application.Run "'Portafoglio Post news.xlsm'!Macro1"
ActiveWorkbook.Save
ActiveWindow.Close
ActiveSheet.Range("$B$2:$AE$700025").AutoFilter Field:=1
Sheets("Test").Select
Application.Run "SL_Test_Dukascopy_.xlsm!Macro2"
Range("O2").Select
[b]ActiveCell.FormulaR1C1 = "25"
[/b]
Range("P2").Select
[b]ActiveCell.FormulaR1C1 = "130"
[/b]
Range("P3").Select
Application.Run "SL_Test_Dukascopy_.xlsm!Macro3"
Sheets("DB").Select
Range("B3:AE700025").Select
ActiveSheet.Range("$B$2:$AE$700025").AutoFilter Field:=1, Criteria1:="<>"
Selection.Copy
Workbooks.Open Filename:="C:\Users\utente\Desktop\Portafoglio Post news.xlsm"
Sheets("Portafoglio globale").Select
Range("A12").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Workbooks.Open Filename:="C:\Users\utente\Desktop\Ottimizzazione_.xlsm"
Sheets("Dati").Select
[b]Range("A4800").Select
[/b]
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Windows("Portafoglio Post news.xlsm").Activate
Sheets("Sintesi ").Select
Range("D2:D36").Select
Application.CutCopyMode = False
Selection.Copy
Windows("Ottimizzazione_.xlsm").Activate
Sheets("DB Ottimizzazioni").Select
[b]Range("N73").Select
[/b]
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Application.CutCopyMode = False
ActiveWorkbook.Save
ActiveWindow.Close
Sheets("Portafoglio globale").Select
Application.Run "'Portafoglio Post news.xlsm'!Macro1"
ActiveWorkbook.Save
ActiveWindow.Close
ActiveSheet.Range("$B$2:$AE$700025").AutoFilter Field:=1
Sheets("Test").Select
Application.Run "SL_Test_Dukascopy_.xlsm!Macro2"
..........
..........