• Skip to primary navigation
  • Skip to content
  • Skip to primary sidebar
  • Skip to footer

danblee.com

Tutorials & Knowledge Base Articles for System Administrators who wear many, many hats.

  • Home
  • About
  • Ask Me
  • DBLHost.com
You are here: Home / Archives for excel functions

excel functions

Display Modified Date of Excel File

December 19, 2012 by Dan B. Lee 11 Comments

In my last post about how to append or prepend text to data in a cell, Larry asked how one might be able to display the modified date of an excel file. This tutorial will explain the most efficient way to display the modified date of the file you are working on in a cell. Get Ready For Macros Getting right to it, the modified date of an excel file exists, but it isn't accessible via any of the functions that Excel has created for us. Instead, we'll create our own function in the Visual Basic … [Read more...] about Display Modified Date of Excel File

Filed Under: Microsoft Excel Tagged With: excel functions, macros, public functions

Primary Sidebar

Categories

  • Active Directory
    • Group Policy
  • Adobe Photoshop
  • Browsers
    • Chrome
  • Cloud Based Technology
    • Citrix XenApp
  • ConnectWise
    • LabTech
  • Dell
  • Internet Service Providers (ISPs)
  • iPhone
  • Linux
    • CentOS
    • OpenVPN
    • SaltStack
    • Ubuntu
  • Microsoft Office
    • Lync
    • Microsoft Excel
    • Microsoft Outlook
    • Microsoft Word
  • Microsoft Windows
    • Active Directory
    • PowerShell
    • Windows 7
    • Windows 8 Preview & Release
  • Networks
  • News
  • Off Topic
  • Office 365
  • Peripherals
    • Monitors
  • Printers
    • Local Printers
    • Network Printers
  • Programming
    • Python
  • Riverbed
  • Security
  • Sharepoint
  • Social Media
  • Splunk
  • Storage
  • Switching & Routing
    • Cisco
    • Fortinet
  • Technology Culture
    • Opinion
  • Uncategorized
  • Virtualization
    • VEEAM
    • VMware
  • WAMP
  • Web Hosting
    • WHMCS
  • Website Design
  • Windows Server
    • Exchange 2003
    • Exchange 2010
    • Exchange 2013
    • Microsoft SQL
    • Windows Server 2003
    • Windows Server 2008 R2
    • Windows Server 2012
  • WordPress

Footer

Recent Activity

  • VSS Volume Shadow Copy Service - Intro - on Diskshadow, VSSAdmin’s best friend
  • Confluence: Wiki on Diskshadow, VSSAdmin’s best friend
  • Migrating VEEAM Backup Data — danblee.com on Using ROBOCOPY switches for faster, more reliable data moves
  • How to Handle Email Spam From Yourself - TrendsEvo on Anti Spoofing for Domains in Exchange 2016
  • How To Handle Email Spam From Yourself | Lifehacker Australia on Anti Spoofing for Domains in Exchange 2016

Dan Lee

Dan B. Lee works at SyApps, LLC., a Managed Hosting Solutions Firm, as a Senior Network Engineer. Dan has a decade of IT experience and specializes in a number of different disciplines including Virtualization, Web Site Hosting and Design, Network Security, Data Center Architecture, Local and Remote Server Hosting, and Backup & DRS Solutions. Read More…

Links

  • Home
  • About Dan B. Lee
  • Ask Me
  • Privacy Policy

Copyright © 2019 · Genesis Sample Theme on Genesis Framework · WordPress · Log in