How to enter last saved date in Excel workbook
I am using Office Pro Plus 2010 and I wanted to have the last saved date displayed in my document for my records. I found this simple method:
Sheets(“Sheet1”).Range(“A1”).Value = Now
End Sub
I am using Office Pro Plus 2010 and I wanted to have the last saved date displayed in my document for my records. I found this simple method:
After reinstalling Windows on to my PC I noticed that I could not get Sage Line 50 2009 accounting software to load up sample or company data files. After searching I found that there is an issue related to the Windows 10 Anniversary updates. The fix is simple luckily, head over to Ask Sage and…
I have been trying to install WHS2011 on my HP Proliant Micrserver N40L for a couple of days. I installed it on the supplied HDD but ran out of space. After some investigation I found that WHS had made a 60GB system partition and the remainder of the 250gb hdd was spare. I was planning…
After new installation of Windows 7 folders and files were locked and admin permission was required even though account in use was admin. Work around: First switch of UAC – user account control. Technet forum Here’s how I edit the C:WindowsSystem32driversetchosts file. It gave “You don’t have permission to save in this location..” but I solved…
Got this error when trying the windows performance test. Found solution here youtube link delete MSVCR100.dll from windows/system32/ download http://www.microsoft.com/en-us/download/details.aspx?id=5555 and http://www.ascentive.com/support/new/libraryfiles.exe Edit: That did not actually work for me so I just downloaded the dll file and copied it to the folder directly: http://www.dll-files.com/dllindex/dll-files.shtml?msvcr100
I had issues with HDD failure and standard backups were not ideal so I am trying Raid for the first time. I considered a controller card but my motherboard has raid built in. Go to bios (del), advanced>components> change to RAID for IDE SATA. Can be under Storage Configurations. Save and exit. The shortcut is…
Making a list of product SKUs, trying to avoid duplicates. Found this data validation post Click on Data tab>Data Validation Icon Click on the Allow: drop down and change to Custom In Formula field enter: =COUNTIF($A$2:$A$1500,A5)=1 A2 being the start and A1500 being the end of the list. Explanation: The COUNTIF function takes two arguments….