topic Post Reload Macro Not Working? in QlikView

Post Reload Macro Not Working?

james — Wed, 10 Feb 2010 20:25:13 GMT

All, I have 9.0 SR2 and I have a MACRO set to run on post reload, yet it doesn't work.

I am reloading it manually and it still brings up the edit module screen once it gets to the point where the Macro should fire..

Any thoughts?

Post Reload Macro Not Working?

pkelly — Wed, 10 Feb 2010 22:40:18 GMT

If the edit module loads when you reload it normally points to a bug within your edit module script....

Post Reload Macro Not Working?

james — Wed, 10 Feb 2010 23:49:17 GMT

The Macro runs fine

Post Reload Macro Not Working?

rwunderlich — Thu, 11 Feb 2010 02:23:31 GMT


James wrote:
The Macro runs fine

I take it you mean the macro runs fine when executed using the Test button when the document is open.

I'm guessing you are trying to access something that is not available in the PostReload environment. For example, you cannot GetVariable() in PostReload. If you have further questions, please post the macro you are having trouble with and maybe we can suggest a workaround.

-Rob

Post Reload Macro Not Working?

james — Thu, 11 Feb 2010 03:21:41 GMT

Here is the MACRO in question :

sub ExcelExportDSR

set Chart = ActiveDocument.GetSheetObject( "CH100" )

"\\Sales\Test.xls",5

Set obj = ActiveDocument.GetSheetObject("CH600")

"\\Sales\Test.jpg")

end sub

This runs fine when I test is as mentioned and when you execute this via a button.

Any ideas would be greatly appreciated. The workaround I am using today is have a vbs file that opens the file and runs the app. Than after opens it again and on open trigger macro

Post Reload Macro Not Working?

rwunderlich — Thu, 11 Feb 2010 03:40:39 GMT

You can't do this in PostReload. PostReload is "headless" -- there is no GUI so the sheet objects are not rendered.

I think the workaround you are using -- an external task -- is the way others are doing it.

-Rob

Post Reload Macro Not Working?

james — Thu, 11 Feb 2010 04:20:41 GMT

Thanks Rob, good to know!

Re: Post Reload Macro Not Working?

Mon, 06 Aug 2012 11:17:52 GMT

Hi Rob,

I have a simillar issue where I previously run post reload tasks that exported Excel files from object tables without any issues during the night when no-one was in. I have since moved the task to QV 11 server and suddenly the object cannot be created. Yet I do have the macro setting the same in the module.

Is this some functionality lost with 11 or am I missing something undemental here?