How to remove timestamp on a csv file

[gasper21]

Hello I hope everyone is doing well. I'm looking for VBA code that will remove the timestamp on a file that is download every morning.
Sample Open in salesforce-2021-08-04-09-00-06.csv I need the name to be OpenSalesF.csv

Your assistance is greatly apricated.
Best regards

 

[DanteAmor]

I guess there is only one csv file in the folder.
If so, try the following:
Update the line "C:\trabajo\Temp\" with the name of your folder.

Sub renamefile()
  Dim spath As String
  Dim sfile As Variant
  
  spath = "C:\trabajo\Temp\"    'Folder where the csv file is located.
  sfile = Dir(spath & "*.csv")
  If sfile <> "" Then
    Name spath & sfile As spath & "OpenSalesF.csv"
  End If
End Sub

 

[gasper21]

I guess there is only one csv file in the folder.
If so, try the following:
Update the line "C:\trabajo\Temp\" with the name of your folder.

Sub renamefile()
  Dim spath As String
  Dim sfile As Variant
 
  spath = "C:\trabajo\Temp\"    'Folder where the csv file is located.
  sfile = Dir(spath & "*.csv")
  If sfile <> "" Then
    Name spath & sfile As spath & "OpenSalesF.csv"
  End If
End Sub

Dante thank you so much for your assistance! I'm very grateful best regards (Amigo si hablas español muchisimas gracias ) Works great!

 

[gasper21]

Donte, can you help me with this code? I'm trying to save the attachment that is on outlook and rename it to Prime Dist Rpt.csv
here is my code, this save the file however it dosen't rename the file. Can you please advise.
Gracias!!!!

Sub Attsave()
With CreateObject("outlook.application")
For Each it In .GetNamespace("Mapi").GetDefaultFolder(6).Items
For Each it1 In it.Attachments
it1.SaveAsFile "C:\Temp\" & it1.Filename 'Change the path as needed
Next
Next
End With
End Sub

 

[DanteAmor]

I'm trying to save the attachment that is on outlook and rename it

This code corresponds to a different requirement than the initial question in this thread. I suggest you create a new thread for each requirement.

Dante thank you so much for your assistance! I'm very grateful best regards (Amigo si hablas español muchisimas gracias ) Works great!

Your welcome. (Encantado de ayudarte, gracias por comentar)

 

[DanteAmor]

Hi gasper21, You marked a post of yours as a solution, but you must mark the answer that really solved your requirement.

 

[smozgur]

Dante thank you so much for your assistance!

The solution post has been changed as confirmed.
@gasper21: In the future, please mark the post that answered your question, not your own post unless you answer your own question.