You can do all of this without being an admin List Id is easy: Go to a list, switch to classic mode, Click Library->Edit Library – your id is in the URL between %7B abd %7D (%7D is at the end of the url most likely). Those % items represent { and } respectively Site […]
Seems simple enough – well I fought a bit – and rather than re-write an article, I will put a link to a sub-section of another article. Here is the link to help jump you there.
I have a file that is an .xlsx file that has NO code that loads a .xlam file with ease. BUT in the last article, as you can see the .xlam file is on sharepoint. Oh no – what now? It seems .xlam files do load properly whereas sometimes (security/trust issues) the .xlam file needs […]
It seems you CAN run .xlam files from Excel as a central library whereas a year ago (might be more – time flies) this was not allowed. If you have a company that has SharePoint – it is finally ready. Using techniques you ALREADY know – here is how I did it and how credentials […]
It is easy to enable the checkbox in the options screen. The option can also be set via a registry entry (or two). To register a change in the registry, Excel must be restarted, but ALSO it is important to note that when Excel exits, it resets this flag. Excel cannot be running therefore. This […]
This article is simply a super great place to find links to the most used articles imageMso codes for customUI images [MS-CUSTOMUI]: Custom UI XML Markup Specification Absolute Path example of onAction onAction=”‘L:\Directory1\Directory2\Spreadsheet name.xlam\’!MyFavFunctionInExcelsName” and then you need to add a handler called MyFavFunctionInExcelsName(control As iRibbonControl)
There are some pretty cool “on the fly” programmatic things we can do with the VBA references like deleting “MISSING” references (which break code that is referenced UNDER these missing references- that is why they need to be fixed). But to do so requires that the user checks the box ‘Trust access to the VBA […]
Here’s a couple links that explain how to unzip and modify the OpenXML file hierarchy of .xlsx and .xlsm files and how to create custom ribbonUI. This should make it possible to access and modify the customUI ribbon via customXMLParts at runtime. Opening and modifying excel files as zips: https://www.jkp-ads.com/articles/excel2007fileformat02.asp VBA customUI editor: https://yoursumbuddy.com/ribbon-customui-xml-editor/
First, we need to learn where the Cadworx settings are stored.If we can manipulate the constants with variable manipulation – then we have moved one step closer to not needing a mouse. Placing components seems to be quite easy without a mouse. get a list of system variables (nope – not it) spitting command output […]
I am keeping it simple – this is reference that helps me explain things for myself and for my customers. Situation: why do I need RAID 5 when we have 2 NAS’s – it already has redundancy/backup. RAID 5 is not being used for redundancy – it is used to lower the overall cost of […]