What someone asked me was to make the xml readable, and I needed it last week too. The term is called “pretty print” and that is the function or procedure that needs to be performed on the text to make it work. What I use is Notepad++ with the tool plugin called “XML Tools”. Simply […]
Short sweet and to the point – click here.
Some tips understand scope in VBA – this is NOT VB.net perhaps use global variables and use _CAPS so they are readily identified put them in their own VBA module
With VBA, it is generally a solution for one’s self or a small group of individuals. Most of my apps if an exception happens, a yellow line is highlighted in the VBA editor, you investigate the variables LIVE (on thy fly – love that about VBA) and adjust or fix the situation. If the code […]
So there is an application that requires a best guess – but still human interaction to choose which item when there is more than one result returned. So one can make a web service to pull back a pull down and make a form for the user to make a choice allowing quicker spreadsheets to […]
OK – so I am reading stuff that seems a little too geeky, but after asking “what is this late vs. early binding” stuff – I had to know what it was. Here is a simple explanation – even I can understand. It really does (did) not matter – but the main point is summarized […]
A friend mentioned this to me. Because I am working for an EPC (Engineering Procurement Company) that builds 3D models, I immediately put VR and Navis together. It turns out he was just mentioning a cool concept. Nonetheless – if this can all be put together for an EPC, a virtual head tour might not […]
1. Start by finding the function that runs the dialog box in AutoPlant, for me this was the “H.I.D. Stanchion Mount Lighting Fixture”. 2.Open Bentley AutoPlant Class editor. 3.Find the function in the “Class List” window. 4.Double click on the selected class to open the class properties window. 5.After opening the window select the methods […]
Recently, I made an excel spreadsheet stacker where, given a list of excel workbook paths, it would stack them all into one. Then I thought, this would be beyond great to stack Bentley Spec tables on top of one another so we can do a search and troubleshoot quicker. In short, open up the SpecTables […]
Here I am writing to a client explaining which technology is the best. The end use is a one table, muliti-report application. Perhaps a few tables with selection lists, but the main data is in one table. The 2nd phase adds 2 more tables. This company is not a Windows shop, but has no Macs […]