Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Calling VB script macro from load script

Hi all,

This problem is so frustrating and I am sure there is an easy answer...

I have created a vb macro that performs a soap call and then writes the xml that is returned to a file. I can run this from the  front end with a button that activates the macro and everything works just fine.

However when i try and call the script using Let loadfile = MyVBMacro();  in the load script nothing happens!

Is there a security setting I'm missing?

Please help!

Mark

12 Replies
luciancotea
Specialist
Specialist

You want to call ActiveDocument.Fields() at LOAD time. It's not available at that time.

Not applicable
Author

hi,

   can you please mention where the ActiveDocument.Fields() need to be used?

luciancotea
Specialist
Specialist

I didn't said you need, I said you want to call ActiveDocument.Fields() at LOAD time. You can't do that because ActiveDocument.Fields() does not exists at LOAD time.