💻 Software
Importing CSV files into Excel using a macro
Fresh7 days ago
Mar 15, 202692898 viewsConfidence Score0%
0%
Problem
I want to develop a macro where in my Excel worksheet I type a date in a specific cell, and the macro will go into a folder containing text files. A database you could say. I want it to find the corresponding file name which is written as a date, put the data through a delimiter, and paste into the…
Unverified for your environment
Select your OS to check compatibility.
1 Fix
Canonical Fix
Unverified Fix
New Fix – Awaiting Verification
Fix for: Importing CSV files into Excel using a macro
Low Risk
This is more simple than you may think, because you can invoke the Text Import Wizard (or rather, you can use its functionality) from within a macro, there's no need to write a CSV parser or anything fancy like that. In fact, all I've done with the …
Awaiting Verification
Be the first to verify this fix
Sign in to verify this fix