URGENT Help Required to merge two excel reports into one

[vikasmahajan]

Dear All

We have two modules in Qlikview  1  ERP and 2 SIM (Sales And Distribution Module) and sales reports

extracted from this modules saparately . Now  We want to Consolidate this 2 excels into one excel consolidate

and send this to managment.

Any one have Idea how to achive the same URGENT

Thanks

Vikas

[#2]

Hi Use attached .vbs file to merge two excels. rename the attached .txt to .vbs.

Hope this helps.

[vikasmahajan]

Dear Mr.KStreak S

Thanks for prompt response I will  try and  get back to you.

Bye

Vikas

[#4]

UPDATED CODE--

If no any field are common in both table then try this

Mergetable:

load

a, b,c, rowno()

from table1.xlsx;

load

d, e, f, rowno()

from table2.xlsx;

Store Mergetable into D:\Mergetable.xlsx

***************************************************************************************************

If atleast on field common in both table then try this

Mergetable:

load

a, b,c

from table1.xlsx;

join

load

a, e, f, rowno()

from table2.xlsx;

Store Mergetable into D:\Mergetable.xlsx

[vikasmahajan]

What is Option Explicit  in your script ?

[#6]

When Option Explicit appears in a file, you must explicitly declare all variables using the Dim or ReDim statements

[vikasmahajan]

I have attach 2 files this files I want into one excel by macro

Whetehr it is possible ?

Vikas

[vikasmahajan]

Hello

Have try this it is giving error  "Expected end of statement  "

Thanks

Vikas

[vikasmahajan]

I have attached 2 excel files can you please send me correct code to merg into one excel file.

Thanks

Vikas

[#10]

With that script, you can't merge different columns. If you want to merge those excel files you can try below.

1. There are some free excel utilities avilable on the net you can use those (http://jeeshenlee.com/2010/09/23/jmc-excel-join-merge-combine-multiple-excel-sheets-or-excel-workboo...)

2. if you need more customization then you need write your own console application using .Net/java.

Hope this helps.