I would like to take an existing text file (approx 4 megs in size) and manipulate it with VB or VBA (from inside Access in that case) and then ideally place it inside a table format, at the very least ...

Microsoft Excel is one of the most popular spreadsheets used across the globe for both individual and business purposes. It is the one-stop destination for storing, organizing, and manipulating data ...

QUESTION: It's a very slow process to open, save and close Excel files (maybe 10 or 15 minutes) when they are large. It seemed to all start when I kept adding more size to an Excel file with alot of ...