PDA

View Full Version : Solved: How to input data from a text to excel using Excel VBA?



Derry
01-06-2011, 01:50 AM
Hey all,

Thank you all the help last time and here another problem. How to input data from a txt file to a excel file using vba excel? Format is delimited and 1)Tab and 2)Semicolon.

The file is supposed to be in .txt but I changed to .csv for uploading as .txt file can't be uploaded. Change to .txt after downloading.

Thanks!

Bob Phillips
01-06-2011, 02:25 AM
Just do it manually in Excel with the macro recorder on, it will generate the code for you.

Bob Phillips
01-06-2011, 02:37 AM
And please don't cross-post, you are wasting our time - Excel Forum http://www.excelforum.com/excel-programming/758918-how-to-input-data-from-a-text-to-excel-using-excel-vba.html#post2445517

Derry
01-06-2011, 06:29 PM
Sorry and I won't repeat again.