Sub compilXLfile()
'
' compilXLfile Macro
'
'
datefile = InputBox("date du download:yyyymmdd")
ChangeFileOpenDirectory _
"C:\Users\fdaniel\Documents\Cymer\ST\temp download xla\61203\"
Selection.InsertFile FileName:="61203-" & "" & datefile & "-#########-PST-GC-IN.dat", _
Range:="", ConfirmConversions:=False, Link:=False, Attachment:=False
Selection.TypeParagraph
Selection.InsertFile FileName:="61203-" & "" & datefile & "-#########-PST-GD-IN.dat", _
Range:="", ConfirmConversions:=False, Link:=False, Attachment:=False
Selection.MoveDown Unit:=wdLine, Count:=1
Selection.InsertFile FileName:="61203-" & "" & datefile & "-#########-PST-GE-IN.dat", _
Range:="", ConfirmConversions:=False, Link:=False, Attachment:=False
Selection.InsertFile FileName:="61203-" & "" & datefile & "-#########-PST-GS-IN.dat", _
Range:="", ConfirmConversions:=False, Link:=False, Attachment:=False
Selection.MoveUp Unit:=wdLine, Count:=53
Selection.Delete Unit:=wdCharacter, Count:=1
Selection.Delete Unit:=wdCharacter, Count:=1
Selection.Delete Unit:=wdCharacter, Count:=1
Selection.Delete Unit:=wdCharacter, Count:=1
Selection.Delete Unit:=wdCharacter, Count:=1
Selection.Delete Unit:=wdCharacter, Count:=1
Selection.Delete Unit:=wdCharacter, Count:=1
Selection.Delete Unit:=wdCharacter, Count:=1
Selection.MoveUp Unit:=wdLine, Count:=3
Selection.MoveDown Unit:=wdLine, Count:=3
Selection.TypeParagraph
Selection.MoveUp Unit:=wdLine, Count:=114
Selection.MoveDown Unit:=wdLine, Count:=12
Selection.Delete Unit:=wdCharacter, Count:=1
Selection.Delete Unit:=wdCharacter, Count:=1
Selection.Delete Unit:=wdCharacter, Count:=1
Selection.Delete Unit:=wdCharacter, Count:=1
Selection.Delete Unit:=wdCharacter, Count:=1
Selection.Delete Unit:=wdCharacter, Count:=1
Selection.Delete Unit:=wdCharacter, Count:=1
Selection.MoveUp Unit:=wdLine, Count:=347
Selection.MoveDown Unit:=wdLine, Count:=15
Selection.MoveUp Unit:=wdLine, Count:=1
Selection.Delete Unit:=wdCharacter, Count:=1
Selection.Delete Unit:=wdCharacter, Count:=1
Selection.Delete Unit:=wdCharacter, Count:=1
Selection.Delete Unit:=wdCharacter, Count:=1
Selection.Delete Unit:=wdCharacter, Count:=1
Selection.Delete Unit:=wdCharacter, Count:=1
Selection.Delete Unit:=wdCharacter, Count:=1
Selection.Delete Unit:=wdCharacter, Count:=1
Selection.MoveUp Unit:=wdLine, Count:=2
Selection.MoveDown Unit:=wdLine, Count:=2
Selection.MoveUp Unit:=wdLine, Count:=570
Selection.MoveRight Unit:=wdCharacter, Count:=2
Selection.TypeBackspace
Selection.TypeText Text:="A"
ActiveDocument.SaveAs2 FileName:="61203-" & "" & datefile & "-044806281-PST-GA-IN.rtf", FileFormat:=wdFormatRTF, _
LockComments:=False, Password:="", AddToRecentFiles:=True, WritePassword _
:="", ReadOnlyRecommended:=False, EmbedTrueTypeFonts:=False, _
SaveNativePictureFormat:=False, SaveFormsData:=False, SaveAsAOCELetter:= _
False, CompatibilityMode:=0
End Sub
Partager