[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 514
  • Last Modified:

Manipulate Excel creation and modification date

I am wondering if there is any code that I can copy and paste into VBA property or other method to change the date of creation and modification on an excel file.
0
wsjwsj2
Asked:
wsjwsj2
  • 3
  • 2
4 Solutions
 
Saurabh Singh TeotiaCommented:
The easiest way I can think of is to change the date of the computer to the date you want the file creation date to be and  modified date to be..but once its created or modified as in the dates are stored it cant be change..you need to go ahead either create the file again...or modify it again..to save the new dates...
0
 
wsjwsj2Author Commented:
But that would only work if you have the admin right to change the system date. Is there any way to change the date without system admin right?
0
 
Saurabh Singh TeotiaCommented:
No..you cant do the change date without system admin..or i believe you can be a power user to change it...
0
Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

 
wsjwsj2Author Commented:
Is it possible to change excel file date of creation and modification withouth system admin right?
0
 
riteshparakhCommented:
http://www.xcelfiles.com/API_03.html

Good Information here

Ritesh
0
 
Saurabh Singh TeotiaCommented:
I doubt that you wont be able to change without sys-admin..
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now