sprintf and printf for VBA – similar to String.Format in .net
Short sweet and to the point – click here.
Making VBA more like .net – Global Constants
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
Better VBA Error Handling
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 […]
Excel and web services
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 […]
Really geeky stuff – what is late vs. early binding. Also … Dictionaries in VBA
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 […]
Virtual Reality Headset for Navis? Cad? Interesting.
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 […]
Adding text box input to a function
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 […]
Exporting MS Access to Excel using VBA from within Excel – MS Access dB table stacker
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 […]
Comparison of MS Access, Filemaker and distributed ideas like MS SQL Server/ReportServices/ASPX
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 […]
Filemaker Import from XML does not work on Filemaker Go – use InsertFromURL
This is a WT* moment in my opinion. Filemaker Go does not support the Import script function except from Filemaker databases and NOT from XML datasources from a website. Enter “Import From URL script step” to solve my issue. For the interim this means that for a work-around for my deadline, I had to copy the dB, work […]