root01
06-02-2016, 03:15 AM
Hi Guys,
I'm relatively new to programming and vba in general.
I am currently working on a QlikView application and I need to output some data from Qlikview into excel.
My requirements are as follows:
1. Open an existing excel template - Works fine
2. Copy some tables/charts and paste them into excel - Works fine
3. Copy a single table and insert the rows of that table into a range in excel whilst moving everything else down. - Not working
4. Save file - Works fine
My current script is as follows:
Code formatting messed up code; Please repost it
The code above is a simple example. Ideally, for step 3 I would like to copy a table in QlikView (the table could have a different amount of rows depending on selections), count the rows that have been copied into clipboard, insert the required amount of cells and then paste the table.
Could anyone help me out please?
I'm relatively new to programming and vba in general.
I am currently working on a QlikView application and I need to output some data from Qlikview into excel.
My requirements are as follows:
1. Open an existing excel template - Works fine
2. Copy some tables/charts and paste them into excel - Works fine
3. Copy a single table and insert the rows of that table into a range in excel whilst moving everything else down. - Not working
4. Save file - Works fine
My current script is as follows:
Code formatting messed up code; Please repost it
The code above is a simple example. Ideally, for step 3 I would like to copy a table in QlikView (the table could have a different amount of rows depending on selections), count the rows that have been copied into clipboard, insert the required amount of cells and then paste the table.
Could anyone help me out please?