Loop through all workbooks in a folder and read cell content in a spesific cell

**mkvassh** · 05-14-2014, 04:58 AM

Hello,

I want to loop through all workbooks in a folder and read cell content in cell k6 in sheet1. Do any of you have some VBA code I can use?

Regards,
Magne

**apo** · 05-14-2014, 05:12 AM

Once you have read the cell contents of K6 is Sheet 1 of each Workbook.. what do you want to do with that value..?

Example.. should it be listed in COlumn A of the Workbook that is running the code?

**jindon** · 05-14-2014, 05:20 AM

Try

Please Login or Register  to view this content.

**apo** · 05-14-2014, 05:24 AM

or..

Please Login or Register  to view this content.

**mkvassh** · 05-14-2014, 09:45 AM

Thank you for your answers. I can use this

Loop through all workbooks in a folder and read cell content in a spesific cell

LinkBack

Thread Tools

Rate This Thread

Display

Loop through all workbooks in a folder and read cell content in a spesific cell

Re: Loop through all workbooks in a folder and read cell content in a spesific cell

Re: Loop through all workbooks in a folder and read cell content in a spesific cell

Re: Loop through all workbooks in a folder and read cell content in a spesific cell

Re: Loop through all workbooks in a folder and read cell content in a spesific cell

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Read through workbooks in a folder

[SOLVED] read single cell content from sheet of closed file and put it in a cell on an active sheet

Macro to read cell content in any order

read cell content and use with Hyperlinks.Add Cell

Please help a n00b, cell input dictating another cells content, read on!.......

Bookmarks

Bookmarks

Posting Permissions