<div>
Set the columns you don't want to hidden. &nbsp;Export to Excel. &nbsp;You're wanting to script this or do it manually?
</div>


Set the columns you don't want to hidden.  Export to Excel.  You're wanting to script this or do it manually?

<div>
Well its needs to be scripted bc of the way the report needs to look
</div>


Well its needs to be scripted bc of the way the report needs to look

<div>
<blockquote>
needs to be scripted bc of the way the report needs to look
</blockquote>
I don't follow you on this... <br />
<br />
Can you explain what you are trying to achieve? &nbsp;<br />
What are the reasons for exporting to Excel in the first place. &nbsp;<br />
Why do you not just have another pivot table with only the columns you want with an Export to Excel button on the caption bar?<br />
<br />
If I have a good idea what you're trying to achieve I can suggest how to get there.
</div>


> needs to be scripted bc of the way the report needs to look

I don't follow you on this...

Can you explain what you are trying to achieve?  
What are the reasons for exporting to Excel in the first place.  
Why do you not just have another pivot table with only the columns you want with an Export to Excel button on the caption bar?

If I have a good idea what you're trying to achieve I can suggest how to get there.

<div>
bc the way they want the report in excel.. they want one sheet to be the pivot table and other sheets are summaries based on it
</div>


bc the way they want the report in excel.. they want one sheet to be the pivot table and other sheets are summaries based on it

<div>
<div class="content wysiwyg-content">
loop through a pivot table that is stored in memory from qlikview and exporting certain columns into excel?
</div>
</div>


loop through a pivot table that is stored in memory from qlikview and exporting certain columns into excel?

VBScript (Visual Basic Scripting Edition) is an interpreted scripting language developed by Microsoft that is modeled on Visual Basic, but with some important differences. VBScript is commonly used for automating administrative and other tasks in Windows operating systems (by means of the Windows Script Host) and for server-side scripting in ASP web applications. It is also used for client-side scripting in Internet Explorer, specifically in intranet web applications.

VB Script

Software is any set of instructions that directs a computer to perform specific tasks or operations. Computer software consists of programs, libraries and related non-executable data (such as documentation). Computer software is non-tangible, contrasted with computer hardware, which is the physical component of computers. Software written in a machine language is known as "machine code". However, in practice, software is usually written in high-level programming languages than machine language. High-level languages are translated into machine language using a compiler or interpreter or a combination of the two.