-
Generating a table from a text file
Hello!
I am in way over my head with a task I've been given and I'm hoping someone can help me out! I am completely new to VBA, so any and all tips are much appreciated.
I have an existing template that I need to add a table to. I've created the header and one blank row to start, and what I'd like to do now is create a module that allows the user to select the file path for a text file, auto-generate the number of rows required, then populate the table with the contents of the selected file.
The data in the text file is separated by tabs, but I also need to leave one blank cell at the end of each row (ie the table has a column that shouldn't be populated with any data).
Does this sound like a plausible task? I'm happy to provide more context if needed! I've been scouring this forum in hopes of finding a good place to start but I'm still at a loss. I'd be grateful for any advice on how to proceed!
Thank you
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules