Posts

Showing posts from April, 2020

Visual Studio adding Signatures (Selfcerts) to applications to run in Excel

Image
Self Cert: Office 365 32-bit  (Subscription based or Click-to-Run version of Office 2016 / 2019) C:\Program Files (x86)\Microsoft Office\root\Office16 Office 365 64-bit  (Subscription based or Click-to-Run version of Office 2016 / 2019) C:\Program Files\Microsoft Office\root\Office16 From: https://docs.microsoft.com/en-us/visualstudio/deployment/how-to-add-a-trusted-publisher-to-a-client-computer-for-clickonce-applications?view=vs-2019 To add a certificate to the Trusted Publishers store under the trusted root Obtain a digital certificate from a CA. (WE are using a self cert) n windows - search for "Manage user certificates"  or "Certificates" Export your selfcert: Suggest dumping it in your CODE folder. Export the certificate into the Base64 X.509 (.cer) format. For more information about certificate formats, see Export a certificate. search for CMD from the start menu - right click and run as administrator Locate certmgr.exe

Xmind create touch file version of files and folder structure to recreate directory structure VBS

This VBS creates a touch folder (zero byte) version of a file/folder structure so it can be dropped (copied) into xmind. ZeroTouchFileFolder.vbs Option Explicit StartZTF ''Zero Touch Files & Folder Replication for folder structure reference Sub StartZTF () Dim CopyStructPath 'as String Dim FileCt 'as Integer Dim FolderCT 'as Integer Dim FSO 'as New FileSystemObject set FSO = CreateObject ( "Scripting.FileSystemObject" ) dim FolderDepth ''limit recurse depth of folders ''msgbox Wscript.Arguments(0) CopyStructPath = Wscript.Arguments ( 0 ) ''"C:\ProgramData\KTGY\ACACustom" ''String to filestruct to copy FolderDepth = InputBox ( "Limit depth of folders to grab, -1 for unlimited: " , "Limit folder depth" , - 1 ) FolderDepth = FolderDepth + 1 Dim strLFP 'as String ''BASE

BAT to copy files over, rename old folder, and make link to new folder in old folder's name.

Note 1. Group Policy must allow user to create symlinks inwindows 10 and 2. Move the RenameAndMkLink.bat to the TARGET folder location - then drag and drop the FROM folder of the RenameAndMkLink.bat file in its new location. for special files like Documents folderd use Windows 10 to relocate. @ echo off @ Echo NOTE: SymLinks must be enabled for user to work via GPO. @ echo Computer Configuration\Windows Settings\Security Settings\Local Policies\User Rights Assignment rem @echo 001 set SourcePath = %~1 IF NOT EXIST %SourcePath% \ NUL goto NOTWINDIR rem @echo 001a set DestDrive = %~d0 rem echo 001b for /f "delims = " %%a in (" %~1 ") do ( set SourceFolder = %%~nxa ) set SourceFolder = %SourceFolder: = % @ echo %sourcefolder% rem pause rem echo 001c set DestPath = %~dp0%SourceFolder% set DestPath = %DestPath: = % rem @echo 002 for /f "tokens = 1 * delims = " %%a in (' date /T') do set SourceDate = %%a @ echo