Import the data from different workbook in 5th row of the current workbook

**vbvba** · 03-23-2015, 06:42 AM

Hi All,

The below VBA code helps me to import all the workbooks from the specified path to the current workbook.

The code works perfectly

However,I want to tweak this code a little, so that I can place the code in 5th row of the current workbook

The below code helps me in placing the data one row below

Please confirm where to change the code, to paste the data in 5th row.

Please Login or Register  to view this content.

**Fettertiger** · 03-23-2015, 04:40 PM

hi,

without testing, just change the following line
Range("A4:IV" & Range("A65536").End(xlUp).Row).Copy
to
Range("A5:IV" & Range("A65536").End(xlUp).Row).Copy

Furthemore you might need to change
Range("A5").Select
to
Range("A6").Select

Let me know if it does what it should do.

Theo

**vbvba** · 03-24-2015, 12:54 AM

Hi,

Thanks for the reply

However, your idea to change the code did not work.
Is there any other way ?

Thanks,

Import the data from different workbook in 5th row of the current workbook

LinkBack

Thread Tools

Rate This Thread

Display

Import the data from different workbook in 5th row of the current workbook

Re: Import the data from different workbook in 5th row of the current workbook

Re: Import the data from different workbook in 5th row of the current workbook

Thread Information

Users Browsing this Thread

Similar Threads

VBA code to copy data from current workbook to another workbook and send email

Can I have Excel search another workbook for data and import it to my current workbook?

Import data from closed workbook, export data to closed workbook - rename current workbook

Import worksheet from different workbook in current workbook (URGENT)

Import Data into Current Workbook

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions