Friday, September 23, 2016

How Can You Fix - Create a reference to document properties such as last modified date and created by?

Create a reference to document properties such as last modified date and created by

I'm trying to create a reference in a cell to document properties such as last modified date and created by.
Does anyone know how?

Solutions to the Problem Create a reference to document properties such as last modified date and created by

Download Error Fixer (Free)

If you want to display the Created_by and Last_Modified values in a worksheet,
you'll need to create a User Defined Function (UDF) using Visual Basic for Applicatons (VBA)

Here's one way:
• ALT+F11.....to open the Visual Basic Editor
• Right-click on your workbook's name in the Project-VBA Project window
...Select: Insert Module

• Copy the below code and paste it into that module:
Function ShowAuthorLastSaved()
    Dim vResult As Variant
    Dim strAuthor As String
    Dim vSavedDateTime As Variant
    Dim strProp As String
   
    strAuthor = "Unavailable"
    vSavedDateTime = "Unavailable"
   
    With ThisWorkbook
        On Error Resume Next
        strProp = "Author"
        vResult = ActiveWorkbook.BuiltinDocumentProperties(strProp)
        If Err.Number = 0 Then
            strAuthor = vResult
        End If
       
        On Error Resume Next
        strProp = "Last Save Time"
        vResult = ActiveWorkbook.BuiltinDocumentProperties(strProp)
        If Err.Number = 0 Then
            vSavedDateTime = vResult
        End If
    End With
    ShowAuthorLastSaved = "Created by: " & strAuthor & " - File last saved: " & vSavedDateTime
End Function

• Save your workbook

Use that function this way:
• In any cell enter:
=ShowAuthorLastSaved()

The cell will display something like: Author: LucyNDisguise - File last saved: 2/23/2010 1:50:50 PM

Is that something you can work with?

Ron Coderre
Microsoft MVP - Excel (2006 - 2010)

P.S.
If any post answers your question, please mark it as the Answer
(That way it won't keep showing as an open item.)

To install drivers and other optional updates

  1. To install optional updates, you need to review and then select them from the list of updates that Windows finds for your computer. Optional updates are not installed automatically.
  2. Open Windows Update by clicking the Start button Picture of the Start button, clicking All Programs, and then clicking Windows Update.
  3. In the left pane, click Check for updates, and then wait while Windows looks for the latest updates for your computer.
  4. If any updates are found, click View available updates.
  5. Select the optional updates that you want, and then click Install. Administrator permission required If you are prompted for an administrator password or confirmation, type the password or provide confirmation.

Another Safe way to Repair the Problem: Create a reference to document properties such as last modified date and created by:

How to Fix Create a reference to document properties such as last modified date and created by with SmartPCFixer?

1. Download Error Fixer. Install it on your system.

2. After the scan is done, you can see the errors and problems which need to be repaired.

3. The Fixing part is finished, the speed of your computer will be much higher than before and the errors have been fixed.


Related: How Can You Update & Download NVidia 6100, 6800 GS/XT Display Driver v.260.89 WHQL,Where to Download NVidia GeForce 8800 GT WHQL-certified driver v.196.21,How to Update & Download NVidia GeForce Go 7400 Display Driver v.260.19.12,[Solved] Download NVidia GeForce GTX 460M Driver v.331.82,Download NVidia Quadro Plex Model IV VGA Driver v.304.43 Certified,Way to Download RealTek RTL8100C(L) Driver v.5.01,Way to Download RealTek RTL8100E Drivers v.694,Way to Update & Download RealTek RTL8101L Auto Installation Program v.6.110 driver,Method to Update & Download RealTek RTL8111G PXE and RPL ROM code v.2.58 driver,How to Update & Download RealTek RTL8411B(N) Driver v.10.003,Best Way to Update & Download ASUS A53SV nVidia Graphics Driver v.8.17.12.6686,Method to Herunterladen ASUS K75VJ Intel Rapid Storage Technology Treiber v.11.6.0.1030,How Can You Update & Download ASUS CG8580 Intel Chipset Driver v.9.3.0.1019,Method to Update & Download ASUS K41VD Intel INF Update Driver v.9.1.1.1015,Way to Update & Download ASUS Pro70T NB Probe v.3.0.0026 driver
Read More: Fast Solution to Problem: Constantly have to reset the wireless connection adapter,[Solved] Constant message that Windows 7 Home Premium not closing down correctly.,How to Fix - Consecutive page numbers keep renumbering themselves from 0?,How to Fix Error - Connection to Internet Explorer has ended before I decide?,Troubleshoot:Copying worksheet line record cell values to individual form style worksheets, one new worksheet form per record line.,Closing Internet Explorer causes error,Compare 2 Tables and Calculate the PROFIT Faster,Computer goes to Windows Boot Manager after Start,Connect to one of my network computer remotely when don't allow exception box Marked,computer locking up randomly

No comments:

Post a Comment