topic Re: run .bat using Macro in QlikView

run .bat using Macro

qlikviewaf — Sat, 16 Nov 2024 20:49:40 GMT

Hi All,

i'm trying to run a .bat file using a macro on my local pc.

How can i do this?

i used this script but nothing happen when i run the macro.

Sub Run_BAT

Set obj = createobject("Wscript.Shell")

obj.Run chr(34) & "C:\ExportMacro\BatchSubstitutetoPickup.bat" & chr(34), 0

Set obj = Nothing

End Sub

Re: run .bat using Macro

Bill_Britt — Tue, 21 May 2019 13:04:36 GMT

Hi,

This will work

Sub Run_BAT

Set obj = createobject("Wscript.Shell")

obj.Run "C:\test\test.bat"

End Sub

Bill

Re: run .bat using Macro

qlikviewaf — Tue, 21 May 2019 13:07:44 GMT

Ciao Bill,

is not working - i click run macro but nothing happen.

Any idea?

Thanks

Re: run .bat using Macro

Bill_Britt — Tue, 21 May 2019 13:14:23 GMT

Hi,

It works for me. See attached video

Bill

Re: run .bat using Macro

marcus_sommer — Tue, 21 May 2019 13:18:57 GMT

Are you sure that the macro and the bat didn't run? Including a msgbox with the file-path (and checking if it's really valid) and a pause statement in the bat would be useful to see what happens.

If the path is valid and the bat runs if it's executed manually check if the macro has system-access (about the mid in the left panel within the macro-editor), the user had not disabled the macro-execution and also that ActiveX is enabled on the machine.

- Marcus

Re: run .bat using Macro

qlikviewaf — Tue, 21 May 2019 13:23:14 GMT

with button is running fine - the only thing is that i think the .bat is running without admin privileges indeed is not mooving file from one folder to another as expected.

Any idea?

Re: run .bat using Macro

Bill_Britt — Tue, 21 May 2019 13:28:01 GMT

Hi,

Just tested moving files and saw no issues.

Can you post your batch file?

Bill

Re: run .bat using Macro

qlikviewaf — Tue, 21 May 2019 13:30:36 GMT

This is the bat

"C:\Users\asaperi\Downloads\fnr.exe" --cl --dir "c:\ExportMacro" --fileMask "*.txt" --excludeFileMask "*.dll, *.exe" --find """" --replace ""

@echo off

For /f "tokens=1,2,3,4,5 delims=/. " %%a in ('date/T') do set CDate=C:\ExportMacro\FattureOrdine%%a%%b%%c%%d.txt

setlocal enabledelayedexpansion

for /f "delims=" %%A in ('findstr /v "Company#Company Address#CAP#City#State#Country#VAT#ORD|Bill#ORD|BillDescription#Address#PostalCode#ORD|Bill|City#Blank#ORD|Bill|Country#TaxID#Bill#Description#Address1#CAP#City#Blank#Country#ORD|OrderNumber#ORD|OrderType#InvoiceDate#InvoiceDate#LineNumber#Remark#InvoiceNumber#InvoiceType#InvoiceDate#DueDate#CodiceUfficio#Blank#Tipo#Descrizione1#Descrizione2#Unit#Qty#UnitPrice#Taxable#Lot#DataScad Testo#VAT %#VAT#Taxable#Total VAT#Gross#Text#DDT#RDM#PEC#CodiceFiscale#RiferimentoAmministrazione#Natura#Tipo Pagamento#Final" "dataOrdine.txt"') do (
echo %%A >>%CDate%
)

:break