I want to select latest report automatically and I created macro but code is something that I am not aware about. Can anyone please help me figure out what would I use that would allow to select latest report file? this VERSIONID I believe is taking date and time that I ran this macro and I don't want to run every day and select file. I want it to either automatically run every day for me and get latest file OR I can run but daily but it should select latest file automatically. Can anyone help me please? and thank you in advance
OPENVIEW SERVERID 'VDRAAAR ' REPORTID 'AFTA0010 ' VERSIONID '20150903151947' EXACTREPORTID ALLEXACT
SCRNPOS 30 1
CARETPOS RELATIVE 30 1
SCRNPOS 4 1
GOTO RELATIVE PAGE 1
SCRNPOS 30 1
CARETPOS RELATIVE 30 1
SCRNPOS 4 1
GOTO RELATIVE PAGE 1
SCRNPOS 30 1
CARETPOS RELATIVE 30 1
SCRNPOS 4 1
GOTO RELATIVE PAGE 1
SCRNPOS 30 1
CARETPOS RELATIVE 30 1
SCRNPOS 4 1
GOTO RELATIVE PAGE 1
SCRNPOS 30 1
CARETPOS RELATIVE 30 1
SCRNPOS 4 1
GOTO RELATIVE PAGE 1
SCRNPOS 30 1
CARETPOS RELATIVE 30 1
SCRNPOS 4 1
GOTO RELATIVE PAGE 1
SCRNPOS 30 1
CARETPOS RELATIVE 30 1
SCRNPOS 4 1
GOTO RELATIVE PAGE 1
SCRNPOS 30 1
CARETPOS RELATIVE 30 1
SCRNPOS 4 1
GOTO RELATIVE PAGE 1
SCRNPOS 30 1
CARETPOS RELATIVE 30 1
SCRNPOS 4 1
GOTO RELATIVE PAGE 1
SCRNPOS 30 1
CARETPOS RELATIVE 30 1
SCRNPOS 4 1
GOTO RELATIVE PAGE 1
SCRNPOS 30 1
CARETPOS RELATIVE 30 1
SCRNPOS 4 1
GOTO RELATIVE PAGE 1
SCRNPOS 30 1
CARETPOS RELATIVE 30 1
SCRNPOS 4 1
GOTO RELATIVE PAGE 1
SCRNPOS 1 1
PRINT COPIES 3 FITBEST CURPAGE
CLOSE
OPENVIEW SERVERID 'VDRAAAR ' REPORTID 'AFTA0011 ' VERSIONID '20150903151544' EXACTREPORTID ALLEXACT
GOTO PAGE 41 SECTIONID ' 000000000000042'
PRINT COPIES 3 FITBEST CURPAGE
CLOSE
OPENVIEW SERVERID 'VDRAAAR ' REPORTID 'AFTA5011 ' VERSIONID '20150903151651' EXACTREPORTID ALLEXACT
GOTO PAGE 50 SECTIONID ' 000000000000051'
SCRNPOS 53 1
GOTO RELATIVE PAGE -1
SCRNPOS 1 1
CARETPOS RELATIVE -7 1
SCRNPOS 53 1
GOTO RELATIVE PAGE -1
SCRNPOS 1 1
CARETPOS RELATIVE -7 1
SCRNPOS 53 1
GOTO RELATIVE PAGE -1
SCRNPOS 1 1
CARETPOS RELATIVE -7 1
SCRNPOS 53 1
GOTO RELATIVE PAGE -1
SCRNPOS 1 1
CARETPOS RELATIVE -7 1
PRINT COPIES 3 FITBEST FROM 46 TO 47
OPENVIEW SERVERID 'VDRAAAR ' REPORTID 'AFTA0010 ' VERSIONID '20150903151947' EXACTREPORTID ALLEXACT
SCRNPOS 30 1
CARETPOS RELATIVE 30 1
SCRNPOS 4 1
GOTO RELATIVE PAGE 1
SCRNPOS 30 1
CARETPOS RELATIVE 30 1
SCRNPOS 4 1
GOTO RELATIVE PAGE 1
SCRNPOS 30 1
CARETPOS RELATIVE 30 1
SCRNPOS 4 1
GOTO RELATIVE PAGE 1
SCRNPOS 30 1
CARETPOS RELATIVE 30 1
SCRNPOS 4 1
GOTO RELATIVE PAGE 1
SCRNPOS 30 1
CARETPOS RELATIVE 30 1
SCRNPOS 4 1
GOTO RELATIVE PAGE 1
SCRNPOS 30 1
CARETPOS RELATIVE 30 1
SCRNPOS 4 1
GOTO RELATIVE PAGE 1
SCRNPOS 30 1
CARETPOS RELATIVE 30 1
SCRNPOS 4 1
GOTO RELATIVE PAGE 1
SCRNPOS 30 1
CARETPOS RELATIVE 30 1
SCRNPOS 4 1
GOTO RELATIVE PAGE 1
SCRNPOS 30 1
CARETPOS RELATIVE 30 1
SCRNPOS 4 1
GOTO RELATIVE PAGE 1
SCRNPOS 30 1
CARETPOS RELATIVE 30 1
SCRNPOS 4 1
GOTO RELATIVE PAGE 1
SCRNPOS 30 1
CARETPOS RELATIVE 30 1
SCRNPOS 4 1
GOTO RELATIVE PAGE 1
SCRNPOS 30 1
CARETPOS RELATIVE 30 1
SCRNPOS 4 1
GOTO RELATIVE PAGE 1
SCRNPOS 1 1
PRINT COPIES 3 FITBEST CURPAGE
CLOSE
OPENVIEW SERVERID 'VDRAAAR ' REPORTID 'AFTA0011 ' VERSIONID '20150903151544' EXACTREPORTID ALLEXACT
GOTO PAGE 41 SECTIONID ' 000000000000042'
PRINT COPIES 3 FITBEST CURPAGE
CLOSE
OPENVIEW SERVERID 'VDRAAAR ' REPORTID 'AFTA5011 ' VERSIONID '20150903151651' EXACTREPORTID ALLEXACT
GOTO PAGE 50 SECTIONID ' 000000000000051'
SCRNPOS 53 1
GOTO RELATIVE PAGE -1
SCRNPOS 1 1
CARETPOS RELATIVE -7 1
SCRNPOS 53 1
GOTO RELATIVE PAGE -1
SCRNPOS 1 1
CARETPOS RELATIVE -7 1
SCRNPOS 53 1
GOTO RELATIVE PAGE -1
SCRNPOS 1 1
CARETPOS RELATIVE -7 1
SCRNPOS 53 1
GOTO RELATIVE PAGE -1
SCRNPOS 1 1
CARETPOS RELATIVE -7 1
PRINT COPIES 3 FITBEST FROM 46 TO 47