I am trying to find the fastest way to store and retrieve a reference to a cell in another workbook. The sheet I am making is a delta record of what a spreadsheet that archives where data USED to be and make a quick link to get back to that data. So – I thought […]
OK – this is cool Writing efficient VBA UDFs Part 10 – Volatile Functions and Function Arguments
First start by reading this very well written article that explains all one needs to know in simple terms. SSDs, Sata I, II, III hard drives, flash drives, thumb drives and SD cards are all discussed. In short lets follow the data flow. The SLOWEST part is what YOU need to address – lets discuss […]
I was asked to look into why 1 of 3 parts of data was 6 days earlier than the other 2 parts. Well it turned out to NOT be IGES data – but it was raw binary data dumps from a LiDAR system. The data was Applanix proprietary data format that is likely written the […]
So I love git and I … anyway – here are are some cool commands and links. IF YOU COMMENT – I will add your findings and your links that helped you find your solution too. Git is not easy. I will keep updating for years to come likely. This extends my first article – […]
A user asked me a question to get past a recurring popups . It seems like this is a 1 time job – so cheezy solutions are acceptable (right!?) Write a quick script to click the annoying popup for you. I did for another example and the code is below on how I did it. […]
C# Installer Intro: This is a more complete list of all of the different processes you might want to have in an installer for c# in visual studio 2017. I have collected this data from across several different people on the internet but there seems to be no complete list anywhere so here you go. […]
Click Continue Reading for … welll more on how to do it. It takes about 5 minutes once you have done it once.
This worked for me finally. https://stackoverflow.com/a/8341110
There are so many little steps to keep people safe etc. that I didn’t want to lose sight of theses instructions. Also- it is very useful for others to know. So, whey not blog here about it and help others along. This was made withe good advise of tall the moms and dads on the […]