Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Commenting a block of code in VBA
- Using Goal Seek on Multiple Cells
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Using LINEST for non-linear curve fitting
- Fitting high order polynomials
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Daily Download 8: Drawing in Excel
- Downloads
- Arrays vs Collections vs Dictionary Objects (and Dictionary help)
- Cubic Splines
Recent Comments
mounir soufi on More on RC design of circular… dougaj4 on More on RC design of circular… mounir soufi on More on RC design of circular… mounir soufi on More on RC design of circular… Sophea CE on Biaxial bending update Sophea CE on Biaxial bending update Python optional argu… on Using Python optional argument… Bill Harvey on Units4Excel Update dougaj4 on Units4Excel Update Bill Harvey on Units4Excel Update dougaj4 on Units4Excel Update Bill Harvey on Units4Excel Update Units4Excel Update |… on Extracting text from an Intern… dougaj4 on Using LinEst() on data with… More on RC design of… on Reinforced Concrete Design for…
Tag Archives: import csv
Dealing with dates 3: opening and saving csv files without data corruption
This post makes use of a spreadsheet for reading data from text files, including comma separated value (csv) files. The latest version includes a routine for saving the imported data in csv format. It can be downloaded (including full open-source … Continue reading
Daily Download 32: Text functions
Today’s daily download covers functions to import data from text files into Excel quickly and efficiently, a function to combine text strings, with improved functionality over the built-in Concatenate function, and functions to extract numbers from the beginning or end … Continue reading
Posted in Excel, UDFs, VBA
Tagged combine text strings, Excel, import csv, Import large files, import text, UDF, VBA
1 Comment
Automatic download of csv files
I was recently asked if I could assist with preparing a spreadsheet to automatically download .csv files from an internet location, with the filename incorporating the date of issue. The process turned out to be quite straightforward, and works well … Continue reading