Code to Import Data from a Closed Workbook

**hammer2** · 08-21-2017, 09:48 PM

Hi Folks

I want to import the entire data from selected sheets in other Workbooks to a main Workbook (MAIN VIEWER) as per the attached samples.

Kind regards
hammer

**Keebellah** · 08-22-2017, 12:50 AM

Hi, I havne't looked at the files yet but the first thing that comes to mind is that a csv file has no multiple sheets so what's the problem?

**hammer2** · 08-22-2017, 01:15 AM

Hi Keebellah ... then that part won't be a problem thanks.

**jindon** · 08-22-2017, 03:34 AM

File name in A2 is not correct.
Assuming csv file and workbook are in the same folder.

Please Login or Register  to view this content.

**hammer2** · 08-22-2017, 04:00 AM

Hi Jindon
That works perfectly! Thanks so much for your time.
Regards
hammer

**mohan.r1980** · 08-22-2017, 07:38 AM

Hi Jindon Sir,

in above case
one thing i would like to ask you that how can we get the rs rows count?
means

Please Login or Register  to view this content.

but how can we get rs rows count e.g. in this case 20 is the count.

**jindon** · 08-22-2017, 07:47 AM

1) add 1 line

Please Login or Register  to view this content.

then

Please Login or Register  to view this content.

This excludes header row in this case, because of the setting "HDR=Yes"

**mohan.r1980** · 08-22-2017, 07:54 AM

Hi Jindon Sir,

Thank you very much

Code to Import Data from a Closed Workbook

LinkBack

Thread Tools

Rate This Thread

Display

Code to Import Data from a Closed Workbook

Re: Code to Import Data from a Closed Workbook

Re: Code to Import Data from a Closed Workbook

Re: Code to Import Data from a Closed Workbook

Re: Code to Import Data from a Closed Workbook

Re: Code to Import Data from a Closed Workbook

Re: Code to Import Data from a Closed Workbook

Re: Code to Import Data from a Closed Workbook

Thread Information

Users Browsing this Thread

Similar Threads

Import data from closed workbook

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

[SOLVED] Code to copy data from a closed workbook and paste in active workbook using named range.

Import data from several closed workbooks to a single sheet in an open workbook

Macro to Import Data from Closed Workbook to CSV File

code to import data from a closed workbook

import data from a closed workbook to another opened workbook

Bookmarks

Bookmarks

Posting Permissions