newfilename

Hello everyone, Sorry in advance if this has already been answered. I would greatly appreciate it if you could link the solution. This is what I'm hoping to execute: I have a "Manual Counts" sheet that I use at work. Every time I use it, I need to save a new copy in a new folder after...

Hi everyone, Here i am trying to copy multiple worksheets to new workbook and below is my code Option Explicit Sub Save_File() Application.EnableEvents = False Dim FlName As String Dim FilePath As String Dim newfilename As String FlName = "Copy" FilePath = Cells(2, "K").Value...

Hello Guys, I would like to run this code on all files from a specific folder. Someone could please help me? Best Regards, Rafael Fernandes Code (from Tommy Miles of Houston, Texas): Sub SplitWorkbook() Dim ws As Worksheet Dim DisplayStatusBar As Boolean DisplayStatusBar =...

Good morning Gents. The following macro attempts to open a new file, take the name of a already opened file and then, save the new file with a variation of the existing file name. ============================== Private Sub CmdB_Invoice_New_Click() CurrentfileName = ActiveWorkbook.Name...

2.5.0.0 Hello guys, I have a VBA code which is working like CUT and PASTE, I was hoping to change it form CUT and PASTE to COPY and PASTE.. any help is very much appreciated :):) Option Explicit Sub MoveFiles() Dim i As Long Dim numRows As Long Dim oldFileName As String Dim...

Hello all. I have code that I've put together in an effort to remove a section of the filename in a series of csv files in a folder. Example "fhw_cpa_denial_report_20180802.csv" and "hmmc_cpa_denial_report_20180802.csv". They all vary in length but all I need to remove is anything after the...

Dear All, I have created the below script that will allow me to delete the last 10 characters from the pdf filenames. It's working - my only problem is that - I cannot find a way how to adjust it so that he do not delete as well the extension (.pdf) of these files... Could you please help me...

hi, I'm looking for a vba that would allow delete last 10 numbers from a file name. 1234561234567899 should be changed to 123456 1454541234566579 should be changed to 145454 etc... I made a google and find out something like below (with few updates from my side)... unfortunately it is not...