Mapping a Drive to new off-prem (office 365) Sharepoint
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.
Make a ‘load xlam’ or ‘load xlsm’ file without any code and in a .xlsx file
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 […]
Using Excel xlam Addons from online SharePoint
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 […]
Enable Excel’s ‘Trust access to the VBA project object model’
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 […]