Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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.