How can I create a batch file

[#1]

How can I create a batch file with the following fields,which are mentioned in the attachment.

[pover]

Do you want to create a vbscript file to run those macros externally?

[#3]

Hi Karl,

Thanks for your co-ordination.Let me explain you briefly.

Suppose I have some information in the report(the information contains with various company )that I will have to send to various person by email for a particular company and it should be send by 1click,but the main thing is that it should take only the required data from the report(I mean to say by filtering).

Presently, it will work by one by one email sending,but I want to do this dynamically,just I will select the company name and the corresponding mail id will be selected and it will filtering the required data which will need to send to the company.

[pover]

Create a file called export.vbs and have it contain something like the following (not tested).

Set MyApp = CreateObject("QlikTech.QlikView")
Set MyDoc = MyApp.OpenDoc (X:\MyQlikviewfile.qvw","","")
Set ActiveDocument = MyDoc

set val=ActiveDocument.Fields("Company").GetOptionalValues
for i=0 to val.Count-1

ActiveDocument.Fields("Company").Select val.Item(i).Text 'Selects a Company
ActiveDocument.GetSheetObject("BU01").Press 'Runs Export Macro

next

You can then set up QV Publisher or Windows Job Scheduler to run the job automatically.

Regards.

[#5]

Hi Karl,

Thanks for your code.I have tested the code & found some debug,so can you send me any sample file to run my application successfully & that would be helpful for my application.

Thanks & Regards.