Store data into excel

[jagannalla]

Hi,

- I had an excel sheet with 3 columns i.e ID(primary Key), MinValue,MaxValue.

- My default in excel sheet i had data for ID column upto 10 rows and there is no data for MInvalue & MaxValue columns.

The following is my Task in Qlikview:

- I had two inbut boxes with two varibables i.e vMinValue, vMaxValue.

- I had list box with ID.

          The ID field is taken from excel sheet.

- Now when i click the button the variables vMinValue should stored under Minvalue and vMaxValue should stored under MaxValue columns of excel sheet based on selection of ID in the list box i.e it should store under particular ID only.

How can i do this? Is it possible to do?

[kaushiknsolanki]

Hi,

     Yes it is possible.

     You can achieve this by using macros to export data to existing excel sheet.

Regards,

Kaushik Solanki

[jagannalla]

how can i do this can you help me.

[kaushiknsolanki]

Hi,

    I am here by  uploading an example.

    Have a look at that

Regards,

Kaushik Solanki

[#5]

Hi Kaushik,

I gave the Full Path of the Excel File in the macro but the document opens without any change.

What else?

ThankYou very very much!