LinkBack URL
About LinkBacks
Hello Everybody,
I want to change the Date of Creation and Time of Excel Workbook (Date of Creation must be in Past). Is it possible using VBA Macro?
Hello Everybody,
I want to change the Date of Creation and Time of Excel Workbook (Date of Creation must be in Past). Is it possible using VBA Macro?
Last edited by kate.middleton1; 01-13-2013 at 11:28 AM.
Kate,
try (assuming date format dd/mm/yyyy, change when needed (do display first)
Please Login or Register to view this content.
If you like my contribution click the star icon!
Hello
Thanks for your reply, i have run this macro in module and save the workbook and close it and when i see the creation date using right click its still the same (which means that the creation date is not set up to the past)...
Last edited by kate.middleton1; 01-13-2013 at 10:40 AM.
Using the statement I gave you, you can change the internal document property. From your comment I get a feeling that you want to change the file object property maintained by the file system. I am not sure whether that can be changed. Maybe someone else can help?
My VBA is pretty much non-existant, but I'm thinking that file creation dates are set by windows, not Excel, and as such, need to be changed through windows.
There are quite a few (free) programs available (google "change file date") that will allow you to change a files attributes (dates etc)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Kate,
Check this link
http://www.visualbasic.happycodings....ves/code3.html
Actually due to the securities purpose i cant download any program to change the excel date. I just need the vba macro to change date (if possible).
Kate, the link I gave you shows you all code needed. The code presented is written in VB but it also works in VBAOriginally Posted by kate.middleton1
Hi,
Ciao,Please Login or Register to view this content.
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
Hello HaHoBe
I have used your code and i give the link of the workbook that i need to change the date of creation. But unfortunately when i see the creation date using right click the date remain unchanged.
@Kate.middleton
I just used HaHoBe code and it worked.
Thanks,
Mike
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
Hello OllieB
The link the you have given to me i didnt now that how to set the past date using this code.
Hallo mike7952
then may be i am using windows7 and this code might not worked on windows 7.
Kate,
Did you close the document properties dialog and reopen it after you ran the code?
Im using windows 7 also, and excel 2003,2007 worked for both.
Hello mike7
can you please share here your tested workbook with working code..
Yes, mike7 you were right this code worked, thanks a lot all of you for my help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks