https://marcushall.net/dokuwiki/ 2026-04-08T21:18:52+00:00 https://marcushall.net/dokuwiki/ https://marcushall.net/dokuwiki/lib/exe/fetch.php?media=wiki:dokuwiki.svg text/html 2021-10-11T00:32:19+00:00 Anonymous (anonymous@undisclosed.example.com) https://marcushall.net/dokuwiki/doku.php?id=software:microsoft:access&rev=1633912339&do=diff PtrSafe Access adjustment for 64 bit 2020-02-26 Compile error 64-bit Change this Private Declare Function OpenProcess Lib "kernel32" (ByVal dwDesiredAccess As Long, ByVal bInheritHandle As Long, ByVal dwProcessId As Long) As Long Private Declare Function GetExitCodeProcess Lib "kernel32" (ByVal hProcess As Long, lpExitCode As Long) As Long text/html 2018-06-29T19:58:56+00:00 Anonymous (anonymous@undisclosed.example.com) https://marcushall.net/dokuwiki/doku.php?id=software:microsoft:excel&rev=1530302336&do=diff How To Quickly Extract Filename From Full Path In Excel From: <https://www.extendoffice.com/documents/excel/1431-excel-extract-filename-from-full-path.html> folder name filename path Function FunctionGetFileName(FullPath As String) As String 'Update 20140210 Dim splitList As Variant splitList = VBA.Split(FullPath, "\") FunctionGetFileName = splitList(UBound(splitList, 1)) End Function text/html 2018-07-28T06:16:00+00:00 Anonymous (anonymous@undisclosed.example.com) https://marcushall.net/dokuwiki/doku.php?id=software:microsoft:office&rev=1532758560&do=diff Excel Freezing computer From: <https://forum.parallels.com/threads/frequent-excel-2013-crashes-under-win-7-in-parallels-are-getting-unbearable.289599/> Also: <https://support.microsoft.com/en-us/kb/2768648> Check the box: File -> Options -> Advanced -> Display Section -> Disable hardware graphics acceleration Fixed by upgrading to newer version New product key for online registration From: office.com/setup text/html 2025-02-26T20:04:24+00:00 Anonymous (anonymous@undisclosed.example.com) https://marcushall.net/dokuwiki/doku.php?id=software:microsoft:outlook&rev=1740600264&do=diff To archive emails older than a specified date in Outlook you can use the Clean up old items feature or set up AutoArchive: Clean up old items Select File > Info > Tools > Clean up old items Select Archive this folder and all subfolders Choose the folder to archive text/html 2018-09-13T20:28:06+00:00 Anonymous (anonymous@undisclosed.example.com) https://marcushall.net/dokuwiki/doku.php?id=software:microsoft:sqlserver&rev=1536870486&do=diff I can't connect to my servers SQL database via an IP Address From: <https://dba.stackexchange.com/questions/62165/i-cant-connect-to-my-servers-sql-database-via-an-ip-address> open SQL Server Configuration Manager; switch to the SQL Server Network Configuration | Protocols for SQLEXPRESS; double-click the TCP/IP protocol; select the Yes value in the Enabled field; switch to the IP Addresses tab;