Discussion Board for collaboration related to QlikView App Development.
I have a macro that exports an object into excel and saves it and emails it to multiple recipients.
Can anyone tell me what command i would use to also delete the file please?
Here is the Export part of the macro.
Sub Export1theDate = Right(String(2,"0") & Day(Now()),2) _ & Right(String(2,"0") & month(Now()),2) _ & Year(Now())
ActiveDocument.ClearAll falsepathcorp="C:\TEST\"set corp = ActiveDocument.GetSheetObject("TB05")corp.ExportBiff pathcorp & "TEST - " & theDate & ".xls"
set MyTable = ActiveDocument.GetSheetObject("TB05")path="C:\TEST\" Set XLApp = NothingSet Table = Nothing
I have also posted this in 'New to Qlikview'