Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Time in hours and minutes between two dates
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Commenting a block of code in VBA
- Using LINEST for non-linear curve fitting
- Arrays vs Collections vs Dictionary Objects (and Dictionary help)
- Using Goal Seek on Multiple Cells
- Retrieving unique values from a range or array ...
- Using Linest for non-linear curve fitting, examples, hints and warnings
- Cubic Splines
- Beam actions and deflections by Macaulay's Method
Recent Comments
Benata on Ana Vidović mindOnion on Drawing a Buckyball in Ex… dougaj4 on Drawing a Buckyball in Ex… mindOnion on Drawing a Buckyball in Ex… mindOnion on Drawing in Excel 7 – Cre… Veronica Davenport on Asymmetric Catenary Function py_UMom spreadsheet… on More on combined shear and ben… Skip on xlwings – dataframes and… dougaj4 on xlwings – dataframes and… More on combined she… on RC Design Functions 9.03; comp… skip on xlwings – dataframes and… skip on mpmath for Excel dougaj4 on mpmath for Excel skip on mpmath for Excel dougaj4 on Composite Beam Spreadsheet Upd…
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