PDA

View Full Version : Modify macro to import text



guatelize
05-19-2011, 12:48 AM
I've found the macro to import big csv files into excel :

http://www.cpearson.com/Excel/ImportBigFiles.aspx

What I wish to modify is a part of it; I need to insert a button in excel that updates automaticaly a specific csv file : "C:\import.csv" and copy into sheet 3 CELL A1;

Another problem occures that the inserted csv file deletes all my formulas starting Col Z to Col AC, is it possible to prevent this ?


Thanks for your help.