Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

macro to write the script from the current QVW to a excel

Hello All

I want a help regarding a macro , the macro will get the script of qvw and will copy it to execl file for comparison purposes.

thnk you.

1 Solution

Accepted Solutions
marcus_sommer

You could use a macro like this: Re: Macro to export Script to get the script and something like this: Macro to paste Text Object in Word to insert it into word - than word is a lot more suitable if you want to compare various scripts or search within them. Where it's not necessary needed to include the script directly into word - saving as txt-file will be enough than word could open them.

Maybe even better would be you used notepad++ with the compare plugin: Notepad++ Compare plugin download | SourceForge.net and the qlik script-language: Re: QlikView in Notepad++‌.

- Marcus

View solution in original post

5 Replies
bindu_apte
Creator III
Creator III

tresesco
MVP
MVP

I am not sure if there is any macro to export the script. However, you can easily do it from script editor:

Ctrl+E -> Alt+F+E   , you can save in your desired format as well.

Anil_Babu_Samineni

Amit, I accept that. Few days back I've got the same thought. That time some one help about the qvw script to specific format. Might be someone help sunny

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
marcus_sommer

You could use a macro like this: Re: Macro to export Script to get the script and something like this: Macro to paste Text Object in Word to insert it into word - than word is a lot more suitable if you want to compare various scripts or search within them. Where it's not necessary needed to include the script directly into word - saving as txt-file will be enough than word could open them.

Maybe even better would be you used notepad++ with the compare plugin: Notepad++ Compare plugin download | SourceForge.net and the qlik script-language: Re: QlikView in Notepad++‌.

- Marcus

Not applicable
Author

yup, I followed the link that you have given and with help of macro code I got the scipr copies into a qvs file. Then i can use it for comparison by some tools available. That solves the issue. Thank you for support.