Change creation date (property statistics)

M

Maurizio

Well-known Member
Joined
Oct 15, 2002
Messages
687
Office Version
  1. 2007
Platform
  1. Windows
Is it possible by vba to change creation date into statistics property ?
Tia.
 

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.
Sort by date Sort by votes
Yes, change this to suit your needs: -

ActiveWorkbook.BuiltinDocumentProperties("Creation Date").Value = #1/1/1946 9:00:00 PM#
 
Upvote 0
You must log in or register to reply here.

Similar threads

M
  • Question
AutoFill within Table Not Correct
Replies
6
Views
195
Joe4
Joe4
LearningByDoing
  • Question
LAMBDA function and its conversion options for locals / regions
Replies
5
Views
134
LearningByDoing
LearningByDoing
A
  • Question
VBA Class Module: Should it be a property?
Replies
3
Views
217
Artik
Artik
M
  • Question
Inserting date from File properties
Replies
1
Views
628
Tetra201
Tetra201
Gringoire
  • Question
Issue with Pivotcaches identification
Replies
1
Views
180
RoryA
RoryA

Forum statistics

Threads
1,216,987
Messages
6,133,886
Members
449,843
Latest member
TheLastLinuxUser

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top