Give me the current date and time in a format that can be saved

[jake_egley]

I want a variable named Time that contains the current date and time in a format that can be saved.

Such that I can use a function like this:

System.IO.File.Copy("C:\filename.xltx", "C:\filename_" & Time & ".xltx")

Thank you

[Curtis_Waguespack · Accepted solution]

Hi @jake_egley ,

Welcome to the forum.

I think something like this should work.

Hope that helps,

Curtis

Dim Time As String = DateTime.Now.ToString("HHmmss")
Logger.Info("Current Time: " & Time)

Dim oDate As String = DateTime.Now.ToString("MMddyyyy")
Logger.Info("Formatted Date: " & oDate)

System.IO.File.Copy("C:\filename.xltx", "C:\filename_" & oDate & "_" & Time & ".xltx")

[jake_egley]

@Curtis_Waguespack That works, thanks. What is the purpose of the Logger lines?

[Curtis_Waguespack]

Log Statements:

https://help.autodesk.com/view/INVNTOR/2023/ENU/?guid=GUID-BE996AA3-DE49-4765-86A7-129DD7B42A4A

[jake_egley]

@Curtis_Waguespack I am now trying to write this into a macro in VBA and it doesn't work, how do you write it in VBA?

[Curtis_Waguespack]

@jake_egley 

I didn't test/run this... but it would be something like this for VBA

Dim Time As String
Set Time = DateTime.Now.ToString("HHmmss")

Dim oDate As String
Set oDate = DateTime.Now.ToString("MMddyyyy")

Call System.IO.File.Copy("C:\filename.xltx", "C:\filename_" & oDate & "_" & Time & ".xltx")