topic Re: How to send data to excel all at once to multiple excel sheets in one workbook? in QlikView

How to send data to excel all at once to multiple excel sheets in one workbook?

Wed, 03 Sep 2014 15:17:43 GMT

Hi,

I have table in qvw. the fields are ID, Name, Add. I want to send the information to excel and in the excel sheet Add should be splited in multiple sheets. Please see the attached sample qvw and can anyone please suggest me how to send the data at once where Add is splited in sheets.

for eg: The Add field have data A,B,CC,DD,L........

I want the excel sheet have ID, Name ,Add where Add=A in one sheet and ID, Name ,Add where Add=B in second sheet and ID, Name ,Add where Add=DD in third sheet and so on.

The original excel sheet have millions of Add. So, I was thinking whether is there any way to process this quickly. I have been trying this so many day but nothing working.

Thanks.

Re: How to send data to excel all at once to multiple excel sheets in one workbook?

Wed, 03 Sep 2014 15:18:19 GMT

Please see attached and help me as I have been struggling with this.

Re: How to send data to excel all at once to multiple excel sheets in one workbook?

ecolomer — Wed, 03 Sep 2014 15:24:42 GMT

Here you have two example

Re: How to send data to excel all at once to multiple excel sheets in one workbook?

Wed, 03 Sep 2014 15:35:08 GMT

Thanks for your prompt reply. I have tried this when I am test the macro it is showing

Object required: 'ActiveDocument.GetSheetObject(...)'

Please help me

Re: How to send data to excel all at once to multiple excel sheets in one workbook?

Wed, 03 Sep 2014 15:41:31 GMT

It is working I have changed

ActiveDocument.GetSheetObject("TB01").CopyTableToClipboard true

But the only thing I need is when I selected Add values in list box as A and CC

I should need to have A data in one sheet and CC data in second sheet. Is there any way I can gt this. Please help me if I get this my problem will be solve.

Please help me.

Re: How to send data to excel all at once to multiple excel sheets in one workbook?

Thu, 04 Sep 2014 12:52:32 GMT

Please can I know this to sort out my problem?

Re: Re: How to send data to excel all at once to multiple excel sheets in one workbook?

ashfaq_haseeb — Thu, 04 Sep 2014 13:13:07 GMT

Hi,

Have a look at attached application.

Regards

ASHFAQ

Re: How to send data to excel all at once to multiple excel sheets in one workbook?

Thu, 04 Sep 2014 21:40:45 GMT

Thanks. Can you please tell me which one I have to use as I tried below but it is showing syntax error.

'// ****************************************************************
'// Internal function for adding a new sheet
'// ****************************************************************
Private Function Excel_AddSheet(objExcelApplication, sheetName) ' as Excel.Sheet

'// add a sheet to the last position
objExcelApplication.Sheets.Add , objExcelApplication.Sheets(objExcelApplication.Sheets.Count)

Dim objNewSheet
Set objNewSheet = objExcelApplication.Sheets(objExcelApplication.Sheets.Count)
objNewSheet.Name = left(sheetName,31)

'// return the newly created sheet
Set Excel_AddSheet = objNewSheet

End function

Re: How to send data to excel all at once to multiple excel sheets in one workbook?

Fri, 05 Sep 2014 12:15:16 GMT

Please help me as I have been struggling really to copy and paste each item