Hi does anyone know how to import a .CSV file into an .XLS file using VB?
Printable View
Hi does anyone know how to import a .CSV file into an .XLS file using VB?
You can write vb code in an Excel module. You can open an csv file like you would a text file. Use:
Open FilePath For Input As #1
Do Until EOF(1)
Line Input #1, strInput
DoYourThingWithstrInput()
Loop
something like this.
Hope this helps.