How to read headers from closed file and paste it in new sheet as column using VBA

**Amar321** · 06-27-2016, 03:14 AM

Hello,
I have 10+ files in a folder. i wants to copy all files headers to new sheet as a column. i am able to do this . But i wants to copy file name and sheet name also i tried but not getting data.
plz see the attchments.
C1.JPG

Below is my code:

Please Login or Register  to view this content.

**romperstomper** · 06-27-2016, 04:09 AM

Please add cross-post links to your post in accordance with the forum rules.

How to read headers from closed file and paste it in new sheet as column using VBA

LinkBack

Thread Tools

Rate This Thread

Display

How to read headers from closed file and paste it in new sheet as column using VBA

Re: How to read headers from closed file and paste it in new sheet as column using VBA

Thread Information

Users Browsing this Thread

Similar Threads

VBA Excel: Copy/Paste a column range to another sheet IF column headers match

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

[SOLVED] Match value(s) in column with headers of another sheet and paste a cell value from column

copy sheet and paste into sheet in closed file

Open file, new column, vlookup, copy paste, closed

[SOLVED] Read whole file,Match the headers based on specific condition & write to text file

Using ADO to read closed file does not read formulas

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions