Macro to open previous day.

[jalo]

I need help with this Macro. At the moment I can only use it for the one day specified ie the 1508 but need it to pick up the previous business day. Don't know if there is a simple remedy for this or if a more complex macro is needed. Any help greatly appreciated.

ChDir "L:\ftpin\cdsftp\SWAPS"
Workbooks.OpenText FileName:="L:\ftpin\cdsftp\SWAPS\audtrail.FAI.1508 .txt", _
origin:=xlMSDOS, StartRow:=1, DataType:=xlDelimited, TextQualifier:= _
xlDoubleQuote, ConsecutiveDelimiter:=False, Tab:=True, Semicolon:=False, _
Comma:=True, Space:=False, Other:=True, OtherChar:="~", FieldInfo:= _
Array(Array(1, 1), Array(2, 1), Array(3, 1), Array(4, 1), Array(5, 1), Array(6, 1), Array(7 _
, 1), Array(8, 1), Array(9, 1), Array(10, 1), Array(11, 1), Array(12, 1), Array(13, 1), Array _
(14, 1), Array(15, 1), Array(16, 1), Array(17, 1), Array(18, 1), Array(19, 1), Array(20, 1), _
Array(21, 1), Array(22, 1), Array(23, 1), Array(24, 1)), TrailingMinusNumbers:=True
Sheets("audtrail.FAI.1608").Select


Cheers
Jalo