Close Excel after running Macro vba on Qlikview

Asked

Viewed 61 times

0

Macro 

set obj = ActiveDocument.GetSheetObject("CH1")
obj.Export "caminho_para_salvar_arquivo"

And now I need to close Excel, I used the following command.

obj.Close caminho_para_salvar_arquivo'

And I get the mistake 

Wrong number of arguments or invalid property assignment: "obj.Close"
excel excel-vba macro

  • Try with this command: ActiveWorkbook.Close Savechanges:=True

  • @R.Galamba tbm did not work, but after several attempts, it rolled "obj. Close"

1 answer

2


Problem solving:

obj.Close

Browser other questions tagged excel excel-vba macro

You are not signed in. Login or sign up in order to post.