Posts

Showing posts from May, 2021

How to securely store Connection String details in VBA

Image
From https://stackoverflow.com/questions/3217014/how-to-securely-store-connection-string-details-in-vba How to securely store Connection String details in VBA Asked 10 years, 10 months ago Active 4 years, 2 months ago Viewed 23k times 14 13 I have an Excel Template that has hardcoded Ms Access MDB path in the VBA code used to connect to the Access tables and save, retrieve data. I migrated the MS Access Database over to SQL Server with Integrated Authentic

How to Create a Shortcut for Any "Modern" Windows App

From  https://lifehacker.com/how-to-create-a-shortcut-for-any-modern-windows-app-1722569853 How to Create a Shortcut for Any "Modern" Windows App With Windows 10, lots of built-in apps (like the calculator) are now “Modern UI” apps. Other Modern UI apps (like Netflix) are a lot more useful now that you can run them in a window. There’s just one problem: There’s no obvious way to make shortcuts of these apps so you can put them on your desktop, or start them with an app like Launchy . Luckily, there is a hidden way: Open File Explorer and paste the following in the address bar: %windir%\explorer.exe shell:::{4234d49b-0245-4df3-b780-3893943456e1} Press Enter. You should be greeted with a secret folder containing a bunch of random apps and actions. Find the Modern app you want to create a shortcut to. Right-click on it and choose “Create shortcut”. It’ll show up on your desktop. From there, you can do whatever you want with the shortcut—leave it on your desktop for qu