So “we must use Sharepoint – it is our corporate answer for everything” … Ok, but it is the wrong tool for … never mind – lets just get a solution and in doing so a lot of learning results … and ALOT did. Lets state that SharePoint assumes you have the document and its […]
VBA has an annoying habit of not knowing where “V.B.A.” is located – and, for example, on SOME machines – it can’t find the reference to common functions like “Left()”. Seriously!?. So adding VBA. as a prefix helps that. What is really going on is on some people’s computer it is looking for the office […]
Here are some links into solving this issue. No resolution yet, just articles. Streamed Video Audio Sync Problems on Windows 10 / Realtek Sound audio on videos not synced with video play
I still think Adobe Reader is in fact a virus- but I have to work with it. Lets light this candle. Here is where to start. OK – never mind – you cannot control reader- they REALLY want you to buy adobe. Try this command line reference. Lets hope if works on the current version […]
Ok – so this guy give me the one tip that mattered. Application.Windows(1) is the active window. ALSO – you can change the caption of the window. IF you have a workbook and need to show 2 or more worksheets in as many windows – then it renames the sheets and adds :1 and :2 […]
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 […]