Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Time in hours and minutes between two dates
- Commenting a block of code in VBA
- Cubic Splines
- Using Goal Seek on Multiple Cells
- Using LINEST for non-linear curve fitting
- Rotating Hypercubes
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- 3DFrame - 3D Frame analysis for Excel
- Downloads
- Spherical Geometry and Vincenty's Formulae
Recent Comments
Category Archives: Computing – general
Removing Add-ins
Recently I had problems with an Excel Add-in that was still trying to run, and generating error messages, even after being removed from the add-in list and uninstalled. After much searching and trying suggested methods that didn’t work, I finally … Continue reading
Posted in Computing - general, Excel, Link to dll, Link to Python, VBA
Tagged Add-in problems, Excel, Link to Python, Regedit, Remove add-ins, VBA, Windows registry
Leave a comment
Getting Excel Solver working
Recently I found that for unknown reasons the Excel Solver add-in was not working. Opening the add-ins list from the Devloper tab showed that it had become deactivated (also accessible from File-Options-Add-ins): Clicking the Solver check box returned a message … Continue reading
Posted in Computing - general, Excel
Tagged Excel, Office 365, Solver add-in, Solver disabled
Leave a comment
Free and Simple Tools for Editing Videos
I recently needed to extract 15 minutes from a 45 minute long video, in 5 separate clips. I discovered that there are free tools to do this simply and efficiently, although they are not widely advertised. Here’s how: By default, … Continue reading
Posted in Bach, Computing - general, Newton
Tagged Adobe Merge Videos, Film&TV, Photos, Trim videos
2 Comments
Clearing OneDrive download files in Android
I recently found that downloaded files on OneDrive on my Android pad had almost filled my storage space to capacity, and that the procedure to delete them was not at all obvious. I eventually found a link with detailed instructions … Continue reading
Fast Search Reminder
A recent comment at Opening and searching pdf files from Excel reminded of the linked spreadsheet, which allows pdf files to be opened at a specified page from Excel, and also fast searches of the local hard drive: PdfLink.zip (free download … Continue reading
Posted in Computing - general, Excel, VBA
Tagged Excel, Open pdf from Excel, pdf, search from Excel, VBA, Windows search
2 Comments