troubleshooting Question

Macro to convert a text file to Excel

Avatar of ParaGlow
ParaGlow asked on
Microsoft ExcelMicrosoft OfficeMicrosoft Applications
2 Comments1 Solution106 ViewsLast Modified:
I have a very large text file of more than a million rows of data.  I need a macro which will convert it to several Excel files.  Each Excel file must have two worksheets and each worksheet will have 200,000 rows of data.  Macro will prompt user to navigate to the drive and folder where the text file is saved.  If text file has 1.2 million rows of data, macro will create 3 Excel files each with 2 worksheets.  Each worksheet will have 200,000 rows of data.   Thanks.
ASKER CERTIFIED SOLUTION
BillDL
General Factotum

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros