Save each row as a separate file with the same header

**Choochi** · 02-26-2021, 11:31 PM

I'm looking to export rows of a dataset I have as separate files but with the same header as the parent file. I don't really know much about VBA and if I do this manually it's going to take a long time since I have a lot of such files. Can someone here plz help me out with this? The sample dataset only has 26 columns but the actual datasets include upto 1500+ columns.

**maniacb** · 02-27-2021, 01:24 AM

Try

Please Login or Register  to view this content.

**Choochi** · 02-28-2021, 09:38 AM

Thank you, I changed the filepath a bit, but otherwise this worked like a charm.

Save each row as a separate file with the same header

LinkBack

Thread Tools

Rate This Thread

Display

Save each row as a separate file with the same header

Re: Save each row as a separate file with the same header

Re: Save each row as a separate file with the same header

Thread Information

Users Browsing this Thread

Similar Threads

Save As Separate File

Save each PPT slide as separate file

[SOLVED] writing excel file to separate tab separated text files with header in each

Save each row as a separate .txt file

[SOLVED] Save each row as a separate .xls file

Save each row as a separate .txt file

Save Worksheet As A Separate File Using Cell Name

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions