Overwriting Existing File on Export Macro

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

Currently i have the below script. All it does, is exports a table from Qlikview. However, i need Qlikview to REPLACE the existing file without a prompt from Excel.

XLDoc.DisplayAlerts = False does not work , because although it doesn't display it, it ends up not overwriting the file autmatically.

Please assist.

sub Export

set XLApp = CreateObject("Excel.Application")

XLApp.Visible = True 'you can make it false, if you want to make it in the background

set XLDoc = XLApp.Workbooks.Add

XLDoc.Sheets(1).name = "Export"

set XLSheet = XLDoc.Worksheets(1)

set MyTable = ActiveDocument.GetSheetObject("TB01") 'Change TB01 to the object you want to export to Excel (Object Properties > General tab > far right)

set XLSheet = XLDoc.Worksheets(1) 'Select sheet where data should be pasted

Mytable.CopyTableToClipboard true 'Copy data to Clipboard

XLSheet.Paste XLSheet.Range("A1") 'Paste data starting at A1

XLDoc.DisplayAlerts = False

XLDoc.SaveAs "...............\Sequence.xlsx"

XLDoc.DisplayAlerts = True

End Sub

Re: Overwriting Existing File on Export Macro

marcus_sommer — Mon, 06 Feb 2017 11:55:54 GMT

Try this:

...

XLApp.DisplayAlerts = False

XLDoc.SaveAs "Path\Sequence.xlsx"

XLApp.DisplayAlerts = True

...

- Marcus

Re: Overwriting Existing File on Export Macro

Anonymous — Tue, 07 Feb 2017 04:42:41 GMT

Thanks, I tried this before, seems I put it in the wrong place. this worked perfect thanks.

Regards,

topic Overwriting Existing File on Export Macro in QlikView

Overwriting Existing File on Export Macro

Re: Overwriting Existing File on Export Macro

Re: Overwriting Existing File on Export Macro