Cicode help

OsamaSalih · ‎2022-01-18

Hi Everyone

I am looking for a Cicode code that sets an Excel file name to current date (month-day-year)

can anyone help ?

Osama

RobertSanders · ‎2022-01-19

I have created two cicode functions in the attached text file, simply copy into the cicode editor

Call the function SetFileNameToDate(""C:\Temp\DataLog.xlsx"") with the file that needs changing as the argument.

In the example above the file will be renamed to something like this C:\Temp\01-19-2022.xlsx.

I have not implemented any form of error checking, Eg if the file 01-19-2022.xlsx already exists etc..

Regards

Rob

See Answer In Context

RobertSanders · ‎2022-01-19

I have created two cicode functions in the attached text file, simply copy into the cicode editor

Call the function SetFileNameToDate(""C:\Temp\DataLog.xlsx"") with the file that needs changing as the argument.

In the example above the file will be renamed to something like this C:\Temp\01-19-2022.xlsx.

I have not implemented any form of error checking, Eg if the file 01-19-2022.xlsx already exists etc..

Regards

Rob

OsamaSalih · ‎2022-01-22

HI Rob

thank you for your reply

I need to have more details about how to call the function

with correct syntax

Regards

Osama

RobertSanders · ‎2022-01-24

You simply call the function and pass the Excel file name and path that you want to change Eg

SetFileNameToDate("C:\Temp\DataLog.xlsx")

The Excel File will be renamed to mm-dd-yyyy.xlsx . If you want to call the function by a button on a screen just copy the above into Up Command and change the path and file name to match.

Regards

Rob

OsamaSalih · ‎2022-01-24

Thank you @RobertSanders

The code you provided worked just perfect

Regards

Osama